Listing A: January 2004 Puzzle Solution
WITH
MEMBER [Store].[All Stores].[Best Store] AS 'SUM(TOPCOUNT([Store].[Store City].Members, 1, 
([Time].CURRENTMEMBER)))'
MEMBER [Store].[All Stores].[Worst Store] AS 'SUM(HEAD(ORDER(FILTER([Store].[Store 
City].Members, ([Time].CURRENTMEMBER) > 0), ([Time].CURRENTMEMBER), BASC), 1))'
SELECT
    {[Time].[1997].CHILDREN} ON COLUMNS,
    {[Store].[All Stores].[Best Store], [Store].[All Stores].[USA].[CA].[Beverly Hills], [Store].[All 
Stores].[Worst Store]} ON ROWS
FROM [Sales]
WHERE [Measures].[Unit Sales]