Table: dance_competition
Columns: rank
couple
judges
public
total
vote_percentage
result

Question: When 9 is the rank who are the couple?
SQL: SELECT "couple" FROM dance_competition WHERE "rank" = 9

Question: When roxanne and daniel are the couple what is the highest rank?
SQL: SELECT MAX("rank") FROM dance_competition WHERE "couple" = 'Roxanne and Daniel'

Question: When ellery and frankie are the couple what is the highest total?
SQL: SELECT MAX("total") FROM dance_competition WHERE "couple" = 'Ellery and Frankie'

Question: When 8 is the public what are the results?
SQL: SELECT "result" FROM dance_competition WHERE "public" = 8

Question: When 8 is the public and the result is safe what is the highest rank?
SQL: SELECT MAX("rank") FROM dance_competition WHERE "result" = 'Safe' AND "public" = 8