use BikeStores;

$--1)$ List the first name, last name and phone number for all active staff.

$--2)$ List the complete orders table $($all rows & cols$)$

$--3)$ List the last name and first name of every staff member who doesn't work at

the flagship store $($store #$1).$

$--4)$ List the product name and price for all products that cost $500$ or less.

$--5)$ List the product name, price and category for all products that cost between

$$700$ and $$800.$

$--6)$ Find the category id for cruiser bikes. List the product name, price and

category for all cruisers that cost less than $$400.$

$--7)$ A resort is interested in providing free bicycle use to their customers to

use on surrounding trails. We're going to prepare a bid for them.

$--$ They would like to start with a fleet of $35$ Electra Cruiser $1$ Ladies' $-$

$2018($product id $220)$ bicycles.

$--$ List the product name, list price, order quantity $($called quantity$)$ and

the calculated order price $($called order$\_$total$)$ as a bid for the customer.

$--8)$ List the customer information for all customers who live in El Paso, Houston,

San Antonio and Garland.

$--9)$ Our resort customer is interested in inexpensive children's bike options.

$--$ Find the category id for children's bikes

$--$ List the product id$,$ product name and list price for children's bikes

sorted lowest to highest by price.

$--10)$ How many products do we offer in each product category?