Table: wales_demographics
Columns: status
2001_number_000
2001
2011_number_000
2011

Question: what is the 2001 % for the status widowed or surviving partner?
SQL: SELECT "2001" FROM wales_demographics WHERE "status" = 'Widowed or surviving partner'

Question: How many 2011 % is 7.9?
SQL: SELECT COUNT("2001_number_000") FROM wales_demographics WHERE "2011" = '7.9'

Question: What is the lowest 2011 number (,000)?
SQL: SELECT MIN("2011_number_000") FROM wales_demographics

Question: What is the 2011 number (,000) when the status is separated?
SQL: SELECT "2011_number_000" FROM wales_demographics WHERE "status" = 'Separated'

Question: What si the 2011 number (,000) when 2001 % is 28.1?
SQL: SELECT MAX("2011_number_000") FROM wales_demographics WHERE "2001" = '28.1'