user: Question: If the spectral type is G1V, what is the total distance amount?
Columns: ['HD designation', 'Constellation', 'Distance ( ly )', 'Spectral type', 'Signal power ( kW )', 'Date sent', 'Arrival date']
Types: ['text', 'text', 'text', 'text', 'real', 'text', 'text']
Sample row: ['HD197076', 'Delphinus', '68.5', 'G5V', 126.0, 'August 29, 2001', 'February 2070']
SQL:

assistant: SELECT SUM("Distance ( ly )") FROM "Table" WHERE "Spectral type" = 'G1V';