fbpx

Practice SQL WHERE Conditions | ACDB

This page provides exercises and solutions to help you practice SQL WHERE conditions. 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, and package number for all customers whose last name is “King” (Customers table).
  2. Display all the data from Packages table for packages whose speed is “5Mbps”.
  3. Display the first name, last name, package number and monthly discount for all customers with monthly discount less than 30 (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…