You are working with the Chinook database and are responsible for filtering for the customers that have a value of ‘USA’ in the country column and have a value of ‘Frank’ in the firstname column. 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 have a value of ‘USA’ in the country column and have a value of ‘Frank’ in the firstname column. 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, countryFROM customers–???
SELECT firstname, lastname, country
FROM customers
–???

How many customers live in the USA and have the name Frank?

• 2
• 1
• 3
• 4