·	Number of Subqueries

·	Joins versus EXISTS

·	WHERE versus HAVING

·	GROUP BY Parent Columns

·	Use Table Aliases

·	Use the SQL Definer

·	EXISTS versus IN

·	Used Indexes