course content

Course Content

Intermediate SQL

1. Grouping

GROUP BYChallenge: Number of StationsChallenge: Total Ride Time for Each Subway LineChallenge: Average Ride Time for Each Subway LineChallenge: The Shortest Ride of Each Subway LineHAVINGChallengeMore Complex Filtering

2. Nested Subqueries

Nested Queries

3. Joining Tables

JOIN 2 TablesChallenge: All Flights InformationChallenge: Information about Passenger Flight DepartureChallenge: Find the Number of PassengerJOIN 3 TablesChallenge 1Challenge 2UNION clause

4. Left, Right, and Inner Joins

INNER JOINChallengeLEFT JOINRIGHT JOIN

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