Filtering and Sorting Customer Data by City and Contact Name in SQLite
Easy
164
1
89.6% Acceptance
Introduction
In this lab, you will be working with the SQLite database northwind.sqlite
. Your main task is to construct an SQL query to retrieve specific information from the customers
table.
Objective
Your SQL query should fulfill the following requirements:
- Retrieve the
city
,company_name
, andcontact_name
columns from thecustomers
table. - Filter the records to only include rows where the
city
name contains the letter 'L'. - Sort the resulting data set by
contact_name
in ascending order.
Key Concepts
To complete this lab, you should be familiar with the following SQL operations:
SELECT
for specifying the columns you want to retrieveWHERE
for filtering rows based on a conditionORDER BY
for sorting the results
Good luck!