Table: asp_world_tour_2006_2
Columns: date
location
country
event
winner
runner_up

Question: Which event was held at Manly Beach?
SQL: SELECT "event" FROM asp_world_tour_2006_2 WHERE "location" = 'manly beach'

Question: What was the location of the Havaianas Beachley Classic, held in Australia?
SQL: SELECT "location" FROM asp_world_tour_2006_2 WHERE "country" = 'australia' AND "event" = 'havaianas beachley classic'

Question: Which event was held in Brazil?
SQL: SELECT "event" FROM asp_world_tour_2006_2 WHERE "country" = 'brazil'