Table: miss_united_continent_results_2
Columns: rank
country
miss_united_continent
virreina
1st_ru
2nd_ru
3rd_ru
4th_ru
semifinalists
total

Question: What's the greatest 1st RU that has a 2nd RU less than 0?
SQL: SELECT MAX("1st_ru") FROM miss_united_continent_results_2 WHERE "2nd_ru" < 0

Question: How many semifinalists had a total less than 2, 1st RU greater than 0, 2nd RU was 0 and Miss United Continent of 0?
SQL: SELECT COUNT("semifinalists") FROM miss_united_continent_results_2 WHERE "miss_united_continent" = 0 AND "2nd_ru" = 0 AND "1st_ru" > 0 AND "total" < 2

Question: What rank was Peru with a total greater than 3?
SQL: SELECT MAX("rank") FROM miss_united_continent_results_2 WHERE "country" = 'peru' AND "total" > 3

Question: What is the least 3rd RU that is ranked less than 8 with a 4th RU greater than 0?
SQL: SELECT MIN("3rd_ru") FROM miss_united_continent_results_2 WHERE "4th_ru" > 0 AND "rank" < 8