Multiple choice

What will be the result of the following query?

Select title_id,copies_sold=sum(qty) from sales where ord_date between '1/1/2010 and '12/31/2010' group by all title_id Sales(title_id,qty,ord_date)

  1. All the title id's and quantity of books sold

  2. All the title id's and total quantity sold

  3. Total quantity of books that were sold during the year 2010

  4. All the title id's and quantity of books sold during the year 2010

  5. None of these
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Output: title_id,copies_sold=sum(qty)Condition: ord_date between '1/1/2010 and '12/31/2010' group by all title_id Option 4 is the correct answer.

Keep practicing — related questions