Question: You are working with the tables as shown in this diagram. You need to generate the list of customers who purchased certain car models. Which SQL clause do you use?

  1. LIKE
  2. IN
  3. BETWEEN
  4. HAVING

Answer: The correct answer of the above question is Option B:IN