Table: brit_talent_episodes
Columns: episode
date
official_itv1_rating_millions
weekly_rank
share
official_itv1_hd_rating_millions
total_itv1_viewers_millions

Question: What was the share (%) for the Semi-Final 2 episode? 
SQL: SELECT "share" FROM brit_talent_episodes WHERE "episode" = 'Semi-final 2'

Question: What was the official ITV1 HD rating in millions for the episode that had an official ITV1 rating of 8.98 million?
SQL: SELECT "official_itv1_hd_rating_millions" FROM brit_talent_episodes WHERE "official_itv1_rating_millions" = '8.98'

Question: When was the episode that had a share (%) of 41.5?
SQL: SELECT "date" FROM brit_talent_episodes WHERE "share" = '41.5'

Question: Which episode had an official ITV1 HD rating of 1.185 million? 
SQL: SELECT "episode" FROM brit_talent_episodes WHERE "official_itv1_hd_rating_millions" = '1.185'

Question: What was the official ITV1 rating in millions of the Live Final Results episode?
SQL: SELECT "official_itv1_rating_millions" FROM brit_talent_episodes WHERE "episode" = 'Live final results'

Question: What was the total ITV1 viewers in millions for the episode with a share (%) of 28.9? 
SQL: SELECT "total_itv1_viewers_millions" FROM brit_talent_episodes WHERE "share" = '28.9'