Which station ids never had more than 12 bikes available?
select distinct station_id from status where station_id not in (select station_id from status where bikes_available > 12)
Which ones ever had more than 12 bikes available?
select distinct station_id from status where bikes_available > 12
What are the id and name of the stations that have ever had more than 12 bikes available?
select distinct t1.id, t1.name from station as t1 join status as t2 on t1.id = t2.station_id where t2.bikes_available > 12