New posts in Having Clause

GROUP BY another table that have been grouped with two sub query

SELECT id HAVING maximum count of id

WHERE vs HAVING

Can you use an alias in the WHERE clause in mysql?