Table: melb_transport
Columns: distance
adelaide
brisbane
canberra
melbourne
perth
sydney

Question: How many dollars is listed under Sydney when the distance is 10km?
SQL: SELECT "sydney" FROM melb_transport WHERE "distance" = '10km'

Question: How many distance places have brisbane at $3.80?
SQL: SELECT COUNT("distance") FROM melb_transport WHERE "brisbane" = '$3.80'

Question: How many listings under Melbourne has a distance at 15km?
SQL: SELECT COUNT("melbourne") FROM melb_transport WHERE "distance" = '15km'

Question: What is the distance when brisbane is $4.80?
SQL: SELECT "distance" FROM melb_transport WHERE "brisbane" = '$4.80'

Question: What is the distance when brisbane is $5.20?
SQL: SELECT "distance" FROM melb_transport WHERE "brisbane" = '$5.20'