The Orion.customer 7. Summarizing Data in Groups Use the orion.customer table to

Question

The Orion.customer
7. Summarizing Data in Groups Use the orion.customer table to determine the number oforion star customers of each gender in each country Display columns named Country, Male Customers, and Female Customers. Display only those countries that have more female customers than male customers. Order the report by descending female customers. Add this title to the report: Countries with More Female than Male Customers PROC SQL Output Countries with More Female than Male Customers Male Female Country customers Customers

Explanation / Answer

The query can be

select Country,'Male Customers','Female Customers' from orion.customer

where 'Female Customers' > 'Male Customers'

order by 'Female Customers' desc

Please note that the image of the table is not clear at all and is of very low resolution . The pixels break when i try to zoom in.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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