Table: canada_light_rail
Columns: city
system
category
daily_ridership
as_of
opened
stations

Question: Which Stations are in vancouver, bc?
SQL: SELECT "stations" FROM canada_light_rail WHERE "city" = 'vancouver, bc'

Question: Which category has 5 stations?
SQL: SELECT "category" FROM canada_light_rail WHERE "stations" = '5'

Question: Which Opened has a Category of diesel light rail?
SQL: SELECT MAX("opened") FROM canada_light_rail WHERE "category" = 'diesel light rail'