user: ### NOW ANSWER:
Question: How many games had less than 7 goals scored?
Columns: ['Name', 'Position', 'Period', 'Appearances¹', 'Goals¹', 'Nationality²']
Types: ['text', 'text', 'text', 'real', 'real', 'text']
Sample row: ["David N'Gog", 'Forward', '2006 – 2008', 25.0, 3.0, 'France']
SQL:

assistant: SELECT COUNT("Appearances¹") FROM "Table" WHERE "Goals¹" = 7.0;