Problem: How would you write a query to find the top 10 customers based on unit sales who aren't single and female? Can you do it without listing any of the three other combinations (i.e., single male, married male, and married female)?
Solution: As
Listing A shows, I answered this problem by filtering out the single, female customers before ranking the remaining customers with a TOPCOUNT() function. As you can see in the FILTER(...