Which Share has a weekly Rank of 8 and is dated 15 June?
CREATE TABLE table_name_12 (share VARCHAR, weekly_rank VARCHAR, date VARCHAR)
SELECT share FROM table_name_12 WHERE weekly_rank = "8" AND date = "15 june"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_12 (share VARCHAR, weekly_rank VARCHAR, date VARCHAR) Question: Which Share has a weekly Rank of 8 and is dated 15 June? [/INST] SELECT share FROM table_name_12 WHERE weekly_rank = "8" AND date = "15 june" </s>