use BikeStores;

$--1)$ For each product, list the product id$,$ name, price, category id and category

name.

$--2)$ For each staff member, list their first name, last name, phone number, store

id and store name.

$--3)$ Use the IN operator with a subquery to find the iD$,$ name and list price for

all products in the electric bikes, mountain bikes and road bikes categories.

$--4)$ Repeat #$3$ but this time use the EXISTS operator in your solution.

$--5)$ For each store, show the store id$,$ name and phone number along with the

product name, id and quantity of products held at that store.

$--6)$ Repeat #$5$ but this time order the rows by store then by quantity from

greatest to least.

$--7)$ Use a subquery to find the products that have only $1$ of a particular product

left in stock.

$--$ first find quantities of $1$ in stock

$--$ use the product id col from stocks to show the products's whose info

you want

$--8)$ Find the first name, last name and e$-$mail of all customers that currently

have an order on file with Baldwin Bikes. Make use of at least one subquery.

$--9)$ List the order id$,$ order date, ship date and store name for all orders for

the customer Lizzie Joyner. Do not use any subqueries.

$--10)$ List the quantity of stock each store has for the most expensive product we

carry. Include the store name, product id$,$ quantity, product name and price.

$--$ Hint! use a subquery with max$()$ to accomplish this.