Table: colliery_accidents
Columns: colliery
location
date
year
death_toll
cause

Question: When has a cause of gas explosion, a Death toll smaller than 63, and a Location of penygraig?
SQL: SELECT "date" FROM colliery_accidents WHERE "cause" = 'gas explosion' AND "death_toll" < 63 AND "location" = 'penygraig'

Question: Where has a cause of gas explosion, a Death toll larger than 38 on 10 june?
SQL: SELECT "location" FROM colliery_accidents WHERE "cause" = 'gas explosion' AND "death_toll" > 38 AND "date" = '10 june'

Question: Which Year has a Location of dinas on 13 january?
SQL: SELECT "year" FROM colliery_accidents WHERE "location" = 'dinas' AND "date" = '13 january'

Question: Which Year has a cause of firedamp and a Death toll larger than 11?
SQL: SELECT SUM("year") FROM colliery_accidents WHERE "cause" = 'firedamp' AND "death_toll" > 11

Question: Count the lowest Year which has gas explosion, Colliery of tylorstown colliery, and a Death toll larger than 57?
SQL: SELECT MIN("year") FROM colliery_accidents WHERE "cause" = 'gas explosion' AND "colliery" = 'tylorstown colliery' AND "death_toll" > 57

Question: Which Colliery has a Death toll of 7?
SQL: SELECT "colliery" FROM colliery_accidents WHERE "death_toll" = 7