Table: lottery_stats
Columns: divisions
prize_eur
odds_of_winning_1in
number_of_winning_tickets
in_order_to_win

Question: What are the prizes when 1 is the number of winning tickets?
SQL: SELECT "prize_eur" FROM lottery_stats WHERE "number_of_winning_tickets" = 1

Question: What are the number of winning tickets that have 180.00 as the prize (eur)?
SQL: SELECT "number_of_winning_tickets" FROM lottery_stats WHERE "prize_eur" = '180.00'

Question: How many odd of winning have 6th as the division?
SQL: SELECT "odds_of_winning_1in" FROM lottery_stats WHERE "divisions" = '6th'

Question: What is the prize (eur) for the 6th division?
SQL: SELECT "prize_eur" FROM lottery_stats WHERE "divisions" = '6th'

Question: Which divisions have 565 as the number of winning tickets?
SQL: SELECT "divisions" FROM lottery_stats WHERE "number_of_winning_tickets" = 565