Essential Question: How can I use the where command to do a query in SQL?
Mastery Objectives:
SWBAT use the command where with the proper syntax to conduct a query in SQL.
Do Now:
In the comments below, write a query using select *.
Directions: Open up google docs. Open up the W3 schools editor: https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_where
The editor has the query: SELECT * FROM Customers WHERE Country='Mexico'; run the query and take a screen shot of the results and paste it into google docs. Run the following queries and paste them into google docs and answer the questions. If there is no code, write the code yourself to answer the questions:
SELECT * FROM Customers WHERE Country='Sweden';
How many customers are from Sweden?
How many customers are UK?
How many customers are from Brazil?
SELECT * FROM Customers WHERE City = 'San Francisco'
How many customers are from the city Cork?
How many customers have the postal code 67000?
How many customers have the CustomerName 'Around the Horn'?
How many customers are from Argentina?