• • Hear is the link https://www.w3schools.com/sql/trysql.asp?filename=trysql_op_in
  • for database and it should work there.
  • You must use the appropriate operators
    • e.g., If the goal is to return all customers from Spain, don't do something like this:

       SELECT * FROM [Customers] WHERE CustomerID = '8' OR CustomerID = '22' OR CustomerID = '29' OR CustomerID = '30' OR CustomerID = '69'; 

    • Instead, your answer must correctly use 'Spain' in the SELECT statement
  • If you get stuck, try watching the videos again
  • 90% of the questions I get asked have the answers in the videos
  • If after that, you're still stuck, then please send me a Canvas message
  • I will grade each answer by pasting the statement into https://www.w3schools.com/sql/trysql.asp?filename=trysql_op_in (Links to an external site.) So be sure your answer works in there!
• Don't wait to begin this!
  • It may turn out to be more difficult than you think.

Flag this Question

Question 110 pts

1. Write a SELECT statement to return the names of all customers from Spain

2. Write a SELECT statement to return the names of all customers from Spain or France

3. Write a SELECT statement to return the last name and first name of all employees whose last name begins with 'D'