Untitled

select shape, AVG(average_completion_time) as a  from honeycomb_game
WHERE 

((
  select month from monthly_temperatures 
  where avg_temperature = (select MAX(avg_temperature) from monthly_temperatures)
) = EXTRACT(MONTH FROM date) 

OR 

(
  select month from monthly_temperatures 
  where avg_temperature = (select MIN(avg_temperature) from monthly_temperatures)
) = EXTRACT(MONTH FROM date)
)											
																 
and
																 
EXTRACT(YEAR FROM date) <= (extract(year from now()) - 20)

GROUP BY shape
ORDER by a