Course Resources

Search

Search IconIcon to open search

Last updated Nov 17, 2024

# Select and Filter Data - Practice Assignment

# Practice Questions

In addition to the practice problems from the lesson pages, write queries to do the following:

  1. Select customers who are not from ‘Berlin’ or ‘London’ and are younger than 50. Order the results by age in descending order.

  2. Select customers whose customer name starts with an ‘L’ or an ‘M’. Order the results by Id in descending order.

# Submission Instructions

Please put all SQL queries for the practice questions into a single SQL file. Use comments to label each query with its respective question number. Submit this .sql file for your assignment on Canvas.

# Lessons