During January, most of Mr. Claus\'s staff take some time off in warmer climates

Question

During January, most of Mr. Claus's staff take some time off in warmer climates. One elf however, stayed behind doing OLAP analysis with the data from the previous year. He was interested in relationships between the child's age, gender, and toys requested. The following query would get the kind of information he wants, but not the needed summaries. Modify the query so that it will provide all the information needed including summaries for all ages, genders, toys, and combinations of these. select age, gender, toyName count(*) from ToyOrder group by age, gender, toyName order by age, gender toyName;

Explanation / Answer

SELECT age, gender, toyName, count(*)

from ToyOrder

order by age, gender, toyName;

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.