WHERE lastname LIKE Smith WHERE lastname LIKE Smith WHERE la

       WHERE lastname LIKE ‘Smith
       WHERE lastname LIKE ‘Smith%’
       WHERE lastname LIKE ‘%Smith%’
       WHERE lastname LIKE ‘%Smith

Q2:

       rows in the left table that don’t satisfy the join condition
       unmatched rows from both the left and right tables
       rows in the right table that don’t satisfy the join condition
       the Cartesian product of the two tables

Q3:

       WHERE, HAVING, GROUP BY
       HAVING, WHERE, GROUP BY
       GROUP BY, HAVING, ORDER BY
       ORDER BY, GROUP BY, HAVING

Q4:

       join tables
       summarize data
       use subqueries and functions
       All of the above

Solution

Question 1:

Answer: WHERE lastname LIKE ‘Smith%’

Question 2:

Answer: rows in the right table that don’t satisfy the join condition

Question 3:

Answer: GROUP BY, HAVING, ORDER BY

Question 4:

Answer: All of the above