You are working with the Chinook database and are responsible for filtering for the customers that live in the city of ‘Mountain View’ and work for the company of ‘Google Inc.’ Replace –??? with the missing information to complete the query. (If you want to undo your changes to the query, you can click the Reset button.)

Tools of the Trade: Linux and SQL | Weekly challenge 4 Quiz | 

You are working with the Chinook database and are responsible for filtering for the customers that live in the city of ‘Mountain View’ and work for the company of ‘Google Inc.’ Replace –??? with the missing information to complete the query. (If you want to undo your changes to the query, you can click the Reset button.)

SELECT firstname, lastname, city, companyFROM customers–???
SELECT firstname, lastname, city, company
FROM customers
–???

How many customers live in Mountain View and work for Google Inc.?

  • 2
  • 3
  • 4
  • 1

 

 

Leave a Comment