Filtering Customers by Country in Northwind Database
Easy
62
1
95.5% Acceptance
- 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!