Table: floods_bihar_2006
Columns: year
district
blocks
panchayat
village
human_in_lakh
animal_in_lakh
total_area_in_lakh_ha
cropped_area_in_lakh_ha
crop_damaged_in_lakh_inr
house_affected
public_property_damaged_in_lakh_inr

Question: How many crops were damaged when the public property damage was 1,03,049.60?
SQL: SELECT "crop_damaged_in_lakh_inr" FROM floods_bihar_2006 WHERE "public_property_damaged_in_lakh_inr" = '1,03,049.60'

Question: What is the panchayat when the public property damage was 1,03,049.60
SQL: SELECT MAX("panchayat") FROM floods_bihar_2006 WHERE "public_property_damaged_in_lakh_inr" = '1,03,049.60'

Question: What is the largest village that had 103279 houses affected? 
SQL: SELECT MAX("village") FROM floods_bihar_2006 WHERE "house_affected" = 103279

Question: What is the smallest district that had 33.25 in animals
SQL: SELECT MIN("district") FROM floods_bihar_2006 WHERE "animal_in_lakh" = '33.25'

Question: How many districts had crib damage of 1,164.50?
SQL: SELECT COUNT("district") FROM floods_bihar_2006 WHERE "crop_damaged_in_lakh_inr" = '1,164.50'