Database: bike_1
Question: What are the ids of all stations that have a latitude above 37.4 and have never had less than 7 bikes available?
SQL:
SELECT id FROM station WHERE lat  >  37.4 EXCEPT SELECT station_id FROM status GROUP BY station_id HAVING min(bikes_available)  <  7