user: Question: Name the number of apps for total g is 8
Columns: ['Player', 'Nat', 'Pos', 'L Apps', 'L G', 'C Apps', 'Total Apps', 'Total G']
Types: ['text', 'text', 'text', 'real', 'real', 'real', 'real', 'real']
Sample row: ['Gabernet', 'ESP', 'MF', 15.0, 1.0, 0.0, 15.0, 1.0]
SQL:

assistant: SELECT COUNT("L Apps") FROM "Table" WHERE "Total G" = 8.0;