What are the ids of all stations that have a latitude above 37.4 and have never had less than 7 bikes available?
select id from station where lat > 37.4 except select station_id from status group by station_id having min(bikes_available) < 7