user: ### NOW ANSWER:
Question: Name the total number of golden tickets being Rosen Shingle Creek Resort
Columns: ['Episode Air Date', 'Audition City', 'First Audition Date', 'Audition Venue', 'Callback Date', 'Callback Venue', 'Guest Judge', 'Golden Tickets']
Types: ['text', 'text', 'text', 'text', 'text', 'text', 'text', 'real']
Sample row: ['January 12, 2010', 'Boston, Massachusetts', 'June 14, 2009', 'Gillette Stadium', 'August 13 & 14, 2009', '60 State Street', 'Victoria Beckham', 32.0]
SQL:

assistant: SELECT COUNT("Golden Tickets") FROM "Table" WHERE "Callback Venue" = 'Rosen Shingle Creek Resort';