Tech_Interview_Prep

SQL Fundamentals

SELECT, WHERE, and JOIN — retrieving and combining rows from relational tables.

Q1.What is the difference between `WHERE` and `HAVING`?

Q2.What does an INNER JOIN return that a LEFT JOIN would also include?

Q3.What's the difference between `UNION` and `UNION ALL`?

Q4.In what order does SQL logically evaluate a query's clauses?