Table: aus_stc_results
Columns: position
team
rd_6
rd_7
rd_8
total

Question: What is the sum of total values for Rd 7 less than 8?
SQL: SELECT SUM("total") FROM aus_stc_results WHERE "rd_7" < 8

Question: What is the sum of values of Rd 7 with RD 6 less than 48 and Rd 8 less than 4 for TC Motorsport in a position greater than 1?
SQL: SELECT SUM("rd_7") FROM aus_stc_results WHERE "position" > 1 AND "rd_6" < 48 AND "team" = 'tc motorsport' AND "rd_8" < 4

Question: What is the average value for Rd 8 in a position less than 2 for Audi Sport Australia?
SQL: SELECT AVG("rd_8") FROM aus_stc_results WHERE "team" = 'audi sport australia' AND "position" < 2