CREATE TABLE table_40508 ("Date" CLOB, "Location" CLOB, "Country" CLOB, "Event" CLOB, "Winner" CLOB, "Runner-up" CLOB)

The event rip curl pro mademoiselle is in which location?
SELECT "Location" FROM table_40508 WHERE "Event" = 'rip curl pro mademoiselle'
SELECT "Location" FROM "table_40508" WHERE "Event" = 'rip curl pro mademoiselle'