fbpx

Practice SQL Nested Queries | ACDB

This page provides exercises and solutions to help you practice SQL nested queries. These exercises are based on the ACDB database, and may be performed online or by running the sample schema scripts on your local database server. For additional exercises in other subjects, use this link.
 

Exercises

  1. Display the first name, last name, city and state for all customers who live in the same state as customer number 170 (Customers table).
  2. Display the package number, internet speed and sector number for all packages whose sector number equals to the sector number of package number 10 (Packages table).
  3. Display the first name, last name and join date for all customers who joined the company after customer number 540 (Customers table).

To read more

UpScale Analytics is one of the largest platforms in the world for learning SQL by doing, consisting over 300 SQL exercises at different levels (including solutions), by topics, across over 100 different datasets. More…