You are working with the Chinook database and are responsible for filtering for invoices with a total that is more than 20. 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 invoices with a total that is more than 20. 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 customerid, totalFROM invoices–???
SELECT customerid, total
FROM invoices
–???

How many invoices have a total that is more than 20?

  • 4
  • 1
  • 2
  • 3

 

Leave a Comment