Shopper - Browsing products and sorting results

Don wants a list of new and popular items - i.e. items that are recently added to the product catalog and have many units sold.

ScreenShot

    SELECT product.name, product.dateAdded, SUM(items.count) AS unitsSold 
        FROM purchases UNNEST purchases.lineItems AS items 
        JOIN product ON KEYS items.product 
        GROUP BY product 
        ORDER BY product.dateAdded, unitsSold DESC LIMIT 10

How about sorting by price? - Copy, paste, and run the following query to sort by price (Low to high)

SELECT product FROM product ORDER BY unitPrice DESC LIMIT 100