AdventureWorks medium questions

From SQLZoo
Jump to navigation Jump to search

AdventureWorks: medium questions

A "Single Item Order" is a customer order where only one item is ordered. Show the SalesOrderID and the UnitPrice for every Single Item Order.

Where did the racing socks go? List the product name and the CompanyName for all Customers who ordered ProductModel 'Racing Socks'.

Show the product description for culture 'fr' for product with ProductID 736.

Use the SubTotal value in SaleOrderHeader to list orders from the largest to the smallest. For each order show the CompanyName and the SubTotal and the total weight of the order.

How many products in ProductCategory 'Cranksets' have been sold to an address in 'London'?