user: ### NOW ANSWER:
Question: How many people lived in San Gabriel in the year 2000?
Columns: ['No.', 'Barangay', 'Area (in km 2 )', 'Rank', 'Population (2000)', 'Population (2007)', 'Population (2010)', 'Population Density (2010)']
Types: ['real', 'text', 'text', 'real', 'real', 'real', 'real', 'text']
Sample row: [1.0, 'Bagbaguin', '7.6358', 7.0, 7586.0, 10389.0, 8407.0, '1,100.99']
SQL:

assistant: SELECT COUNT("Population (2000)") FROM "Table" WHERE "Barangay" = 'San Gabriel';