user: ### NOW ANSWER:
Question: Which event was held at Manly Beach?
Columns: ['Date', 'Location', 'Country', 'Event', 'Winner', 'Runner-up']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['February 28-March 12', 'Gold Coast', 'Australia', 'Roxy Pro Gold Coast', 'Melanie Redman-Carr ( AUS )', 'Layne Beachley ( AUS )']
SQL:

assistant: SELECT "Event" FROM "Table" WHERE "Location" = 'Manly Beach';