Table: fibt_champs
Columns: athlete
country
from
gold
silver
total
status

Question: What is the status of rené hoppe?
SQL: SELECT "status" FROM fibt_champs WHERE "athlete" = 'rené hoppe'

Question: How many times does Switzerland have under 7 golds and less than 3 silvers?
SQL: SELECT COUNT("total") FROM fibt_champs WHERE "country" = 'switzerland' AND "gold" < 7 AND "silver" < 3

Question: What athlete has less than 7 gold and 14 total medals?
SQL: SELECT "athlete" FROM fibt_champs WHERE "gold" < 7 AND "total" = 14