CREATE TABLE table_name_47 (loera VARCHAR2, source VARCHAR2, date VARCHAR2)

Which Loera has a Source of surveyusa, and a Date of may 16 may 18, 2008?
SELECT loera FROM table_name_47 WHERE source = "surveyusa" AND date = "may 16–may 18, 2008"
SELECT "loera" FROM "table_name_47" WHERE "date" = "may 16–may 18, 2008" AND "source" = "surveyusa"