Question $1$ to $10(10$ points for each$)$

$$

$1.$ Display CustomerID and CustomerName for all customers whose CustomerName begins with a letter T

$$

$2.$ Display the CustomerName and CustomerZip for all customers, sorted alphabetically by CustomerName.

$$

$3.$ Display the ProductID, ProductName, and ProductPrice for products with a Product Price of $$100$ or higher.

$$

$4.$ Display the ProductID, ProductName, ProductPrice, and VendorName for all products. Sort the results by ProductID.

$$

$5.$ Display the TID, CustomerName, and TDate for sales transactions involving a customer buying a product whose ProductName is Easy Boot.

$$

$6.$ Display the RegionID, RegionName, and number of stores in the region for all regions.

$$

$7.$ For each product category, display the CategoryID and the total number of items purchased in the category.

$$

$8.$ Display the TID and the total number of items $($of all products$)$ sold within the transaction for all sales transactions whose total number of items $($of all products$)$ sold within the transaction is greater than five.

$$

$9.$ Display the ProductID, ProductName, and VendorName for products whose price is below the average price of all products.

$$

$10.$ For each product category, display the CategoryID, CategoryName, and average price of a product in the category.

$$

$$

$$

$$