Question: You are working with the tables as shown in the diagram. You need to generate the list of price totals for each make and model of car, with subtotals for each make, and the grand total of all prices. Which SQL clause do you use?
- UNION
- SHOW TOTALS
- UNION ALL
- WITH ROLLUP
Answer: The correct answer of the above question is Option D:WITH ROLLUP