human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Rank, Nation, Gold, Silver, Bronze, Total
###Question: What is the most gold medals a team with less than 2 silvers, more than 7 total medals, and less than 8 bronze medals has?
gpt
SELECT MAX Gold FROM table WHERE Silver < 2 AND Total > 7 AND Bronze < 8