Table: brit_talent_ratings
Columns: show
date
official_ratings_millions
weekly_rank
share

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

Question: Which Weekly Rank has an Official ratings (millions) of 11.58?
SQL: SELECT "weekly_rank" FROM brit_talent_ratings WHERE "official_ratings_millions" = 11.58

Question: Which Show is dated 9 June?
SQL: SELECT "show" FROM brit_talent_ratings WHERE "date" = '9 june'

Question: Which Weekly Rank for a Live Final Show has an Official Ratings (millions) greater than 5.2?
SQL: SELECT "weekly_rank" FROM brit_talent_ratings WHERE "official_ratings_millions" > 5.2 AND "show" = 'live final'