CREATE TABLE table_name_12 (share VARCHAR2, weekly_rank VARCHAR2, date VARCHAR2)

Which Share has a weekly Rank of 8 and is dated 15 June?
SELECT share FROM table_name_12 WHERE weekly_rank = "8" AND date = "15 june"
SELECT "share" FROM "table_name_12" WHERE "15 june" = "date" AND "8" = "weekly_rank"