CI want the sql code for each qustionreate a list of all Florida and Georgia customers. Display all the customer's information.

Display the information of customers who were born in $1976.$

Count the number of different items of carried by Clearwater Traders.

Display all shipments that have not yet been received.

Calculate the total quantity on hand for each inventory item in the INVENTORY tableignore their different sizes and colors.

Display how many orders were placed in May, $2006,$ and paid by credit card.

Display how many inventory items have an inventory price greater than $$60\mathrm{.}00$ and are available in a size of $L$ or XL$.$

Determine how many orders were received from each of the available order sources $($OS$\_$ID$).$

Display each customer's first and last names and their age in years.

$10.$Display items in stock $($that is INV$\_$QOH $>0)$ that are available in sizes Small, Medium or Large.

CUSTOMER

$\backslash$table$[[$C$\_$ID$,$C$\_$LAST,C$\_$FIRST,C$\_$MI$,$C$\_$DOB,C$\_$ADDRESS,C$\_$CITY,C$\_$STATE,C$\_$ZIP$],[$Number$,$String,String,String,Date$/$Time$,$String,String,String,String$],[1,$Graham,Neal,R$,\frac{12}{10}\frac{?}{1967},9815$ Circle Dr$.,$Tallahassee,FL$,32308],[2,$Sanchez,Myra,T$,\frac{8}{14}\frac{?}{1958},172$ Alto Park,Seattle,WA$,42180],[3,$Smith,Lisa,M$,\frac{4}{12}\frac{?}{1960},850$ East Main,Santa Ana,CA$,51875],[4,$Phelp,Paul,,$\frac{1}{18}\frac{?}{1981},994$ Kirkman Rd$.,$Northpoint,NY$,11795],[5,$Lewis,Sheila,A$,\frac{8}{30}\frac{?}{1978},195$ College Blvd$.,$Newton,GA$,37812],[6,$James,Thomas,E$,\frac{6}{01}\frac{?}{1973},348$ Rice Lane,Radcliff,WY$,87195]]$

ITEM

$\backslash$table$[[$ITEM$\_$ID$,$ITEM$\_$DESC,CAT$\_$ID$,$ITEM$\_$IMAGE$],[$Number$,$String,Number,String$],[1,$Men's Expedition Parka,$3,$parka.jpg$],[2,3-$Season Tent,$4,$tents.jpg$],[3,$Women's Hiking Shorts,$1,$shorts.jpg$],[4,$Women's Fleece Pullover,$1,$fleece.jpg$],[5,$Children's Beachcomber Sandals,$2,$sandals.jpg$],[6,$Boy's Surf Shorts,$2,$surfshorts.jpg$],[7,$Girl's Soccer Tee,$2,$girlstee.jpg$]]$

ORDER$\_$LINE

$\backslash$table$[[$OIID$,$INVIID,OL$\_$QUANTITY$],[$Number$,$Number,Number$],[1,1,1],[1,14,2],[2,19,1],[3,24,1],[3,26,1],[4,12,2],[5,8,1],[5,13,1],[6,2,1],[6,7,3]]$

SHIPMENT

$\backslash$table$[[$SHIP ID$,$SHIP$\_$DATE EXPECTED$],[$Number$,$Date$/$Time$],[1,\frac{09}{15}\frac{?}{2006}$