northwind
10 MOST EXPENSIVE PRODUCTS
SELECT TenMostExpensiveProducts AS [Product Name],UnitPrice AS [Price per Unit]
FROM [Ten Most Expensive Products]
ORDER BY UnitPrice DESC
CATEGORY SALES FOR 1997
SELECT CategoryName,CategorySales
FROM [Category Sales for 1997]
ORDER BY CategoryName