Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Price Filter Join Challenge
course content

Course Content

Intermediate SQL

Price Filter Join ChallengePrice Filter Join Challenge

Task

  1. You need to get the names (name column from the product table) and price (price column from the price table);
  2. Join these tables using the INNER JOIN by product_id column;
  3. The price must be the following values: (10, 4, 2). For it use the IN keyword;
  4. Take the first 5 records.

Here's a short example of the product table:

nameproduct_id
Twinings Earl Grey tea1
Rice3
Chicken meat4
......
Nescafe Gold14

Here's a short example of the price table:

product_idprice
110
28
......
1415

Everything was clear?

Section 4. Chapter 2
toggle bottom row
some-alt