Database: bike_1
Question: What are the names and ids of all stations that have more than 14 bikes available on average or had bikes installed in December?
SQL:
SELECT T1.name ,  T1.id FROM station AS T1 JOIN status AS T2 ON T1.id  =  T2.station_id GROUP BY T2.station_id HAVING avg(T2.bikes_available)  >  14 UNION SELECT name ,  id FROM station WHERE installation_date LIKE "12/%"