Table: streetcar_history
Columns: date
builder
type
operator
number
withdrawn
status

Question: List the builder from 1930.
SQL: SELECT "builder" FROM streetcar_history WHERE "date" = '1930'

Question: List the number of builders where the withdrawn is 1951 and number is 42.
SQL: SELECT COUNT("builder") FROM streetcar_history WHERE "withdrawn" = '1951' AND "number" = '42'

Question: List the date for number 1.
SQL: SELECT "date" FROM streetcar_history WHERE "number" = '1'

Question: List the number for the operator melbourne and metropolitan tramways board.
SQL: SELECT "number" FROM streetcar_history WHERE "operator" = 'Melbourne and Metropolitan Tramways Board'

Question: List the status for the operator Toronto transit commission.
SQL: SELECT "status" FROM streetcar_history WHERE "operator" = 'Toronto Transit Commission'