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

Question

       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

Explanation / Answer

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

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.