DRAG DROP
You are creating queries for a shopping cart application.
You have the following requirements:
– Query1 must list products where less than 100 units have been sold in total.
– Query2 must list products where more than 10 units have been sold in a single order.
You need to identify the correct sub-queries to complete the outer queries that you have written.
Which Transact-SQL statement or statements should you use? To answer, drag the appropriate SQL statements to the correct locations. Each SQL statement may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Answer: 