Hang on...
Filtering Customers by Country in Northwind Database
- Retrieve the following columns:
contact_name
,address
, andcity
from the tablecustomers
- The query should only include customers that are NOT from the countries
Germany
,Mexico
, orSpain
.
customers
table schema
customer_id
company_name
contact_name
contact_title
address
city
region
postal_code
country
phone
fax
Important Concepts
- SQL
SELECT
statement: Used to specify the columns that should be returned in the result set. - SQL
WHERE
clause: Used for filtering records based on specific conditions. - SQL
NOT IN
clause: Used to exclude records that match values in a list.
Remember, the database contains all the information you need to construct the query. Good luck!
Adding your container request
Getting your dedicated container
Connecting to your container
Setting up your editor
Finalizing your playground
TerminalEditorBrowser