human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Position, Team, Rd 6, Rd 7, Rd 8, Total
###Question: What is the sum of total values for Rd 7 less than 8?
gpt
SELECT SUM Total FROM table WHERE Rd 7 < 8