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

Question: Name the rank for mikey and melanie
SQL: SELECT "rank" FROM dance_show_results_4 WHERE "couple" = 'Mikey and Melanie'

Question: Name the public for mikey and melanie
SQL: SELECT "public" FROM dance_show_results_4 WHERE "couple" = 'Mikey and Melanie'

Question: Name the judges for 4 public
SQL: SELECT "judges" FROM dance_show_results_4 WHERE "public" = 4

Question: Name the total number for 3 public
SQL: SELECT COUNT("total") FROM dance_show_results_4 WHERE "public" = 3