Skip navigation

April 2003 MDX Puzzle

Find the top 10 drink products based on store sales. For the purposes of this puzzle, a product is a drink product if it's in a product category with the name Beverage or Drink in its title. Format the results so that the top 10 drink products are listed on the rows and the store sales are displayed in a single column.

TAGS: SQL Server
Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.