Having in sql. Cross join sql. drop sql. group by sql. count distinct sql.