course content

Course Content

Intermediate SQL

ChallengeChallenge

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