user: Question: How many golden tickets were given out when the auditions were held in san francisco, california?
Columns: ['Episode Air Date', 'Audition City', 'Date', 'First Audition Venue', 'Callback Date', 'Callback Venue', 'Golden Tickets']
Types: ['text', 'text', 'text', 'text', 'text', 'text', 'real']
Sample row: ['January 13, 2009', 'Phoenix, Arizona', 'July 25, 2008', 'Jobing.com Arena , Glendale', 'September 2008', 'The Boulders, Scottsdale', 27.0]
SQL:

assistant: SELECT SUM("Golden Tickets") FROM "Table" WHERE "Audition City" = 'san francisco, california';