user: ### NOW ANSWER:
Question: What is the least 3rd RU that is ranked less than 8 with a 4th RU greater than 0?
Columns: ['Rank', 'Country', 'Miss United Continent', 'Virreina', '1st RU', '2nd RU', '3rd RU', '4th RU', 'Semifinalists', 'Total']
Types: ['real', 'text', 'real', 'real', 'real', 'real', 'real', 'real', 'real', 'real']
Sample row: [1.0, 'Dominican Republic', 2.0, 1.0, 0.0, 0.0, 0.0, 0.0, 2.0, 5.0]
SQL:

assistant: SELECT MIN("3rd RU") FROM "Table" WHERE "4th RU" > 0.0 AND "Rank" < 8.0;