JOINs, subqueries, aggregations, GROUP BY, and data manipulation
What is an INNER JOIN?
What is the difference between LEFT JOIN and RIGHT JOIN?
What is a FULL OUTER JOIN?
What is a CROSS JOIN?
What is a self join?
What is the difference between WHERE and HAVING?
Which aggregate function returns the number of rows?
What is a subquery in SQL?
What is the difference between UNION and UNION ALL?
What does GROUP BY do in SQL?
What is a correlated subquery?
What is the purpose of the COALESCE function?
What is the difference between CHAR and VARCHAR data types?
What does the EXISTS operator do?
What is the CASE expression used for?
What is normalization in databases?
What is the difference between DELETE, TRUNCATE, and DROP?
