You are working with the Chinook database and are responsible for filtering for customers that live in the country of ‘USA’ and the state with an abbreviation of ‘CA’. 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 customers that live in the country of ‘USA’ and the state with an abbreviation of ‘CA’. 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, address, countryFROM customers–???
SELECT firstname,lastname, address, country
FROM customers
–???

What are the first names of the customers that live in the USA and the state with an abbreviation of CA?

• Frank, Tim, Dan, Heather, Kathy
• John, Michelle, Julia, Patrick
• Kathy, Michelle, Frank
• Frank, Tim, Dan