Table: uk_tv_ratings_2
Columns: rank
show
number_of_viewers
date
network

Question: Which Network has a Rank larger than 5, a Show of 2012 summer olympics closing ceremony in london?
SQL: SELECT "network" FROM uk_tv_ratings_2 WHERE "rank" > 5 AND "show" = '2012 summer olympics closing ceremony in london'

Question: Which Rank has a Network of bbc one, and a Number of Viewers of 30.15million? Question 2
SQL: SELECT SUM("rank") FROM uk_tv_ratings_2 WHERE "network" = 'bbc one' AND "number_of_viewers" = '30.15million'

Question: When has a Rank larger than 2 and a Network of itv?
SQL: SELECT "date" FROM uk_tv_ratings_2 WHERE "rank" > 2 AND "network" = 'itv'