just write the codes , thank you
For all cases, use Notepad or another text editor to write a script using the specified filename. Always use the search condition text exactly as the question specifies. Place the queries in the order listed, and save the script files in an appropriate folder on your Data Disk. If you haven't done so already, run the Ch3Clearwater.sql script to create and populate the case study database tables (the script is on blackboard). All the following cases are based on the Clearwater Traders database. 1. Create a list of all Florida and Georgia customers. Display all the customer's information. 2. Display the information of customers who were born in 1976. 3. Count the number of different categories of inventory are carried by Clearwater Traders. 4. Display all shipments that have not yet been received. 5. Calculate the total quantity on hand for each inventory item in the INVENTORY table ignore their different sizes and colors. 6. Display how many orders were placed in May, 2006, and paid by credit card. 7. Display how many inventory items have an inventory price greater than $60.00 and are available in a size of L or XL. 8. Determine how many orders were received from each of the available order sources (OS_ID). 9. 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 Medium or Large and are available in the colors Royal, Bright Pink, or Spruce. CAT ID Number 3 4 1 1 2. 2 2 ITEM IMAGE String parka.pe tents.198 Shorts fleece. sandals. surfshorts. 128 girlstee.ID CUSTOMER C.ID C LAST C FIRST C MI CI DOB C ADDRESS C CITY C STATE CZIP Number String String Strine Date/Time String String String 1 Graham Neal R 12/10/1967 9815 Cinde Dr. Talahassee FL 32308 2 Sanchez Myra T 8/14/1955 172 Alto Park Seattle WA 42100 3 Smith LIS M 4/12/1960 350 East Main Santa Ana CA 51875 4 Phelp Paul 1/10/1981 994 Kirkman Rd Northpoint NY 11795 5 Lewis Sheila 8/30/1978 195 College Blvd Newton GA 37812 6 James Thomas E 6/01/1973 34 Rice Lane Radell WY 87195 CUSTOMER (continued) ITEM CDPHONE C EPHONE CUSERID C PASSWORD ITEM ID ITEM DESC String String String String Number String 9045551897 9045558599 barbiecar 1 Men's Expedition Parka 4185551791 4185556643 sanchez qwerts 2 3-Season Tent 3075557841 3075559052 smithim Joshua 3 Women's Hiking Shorts 4825554788 4325558219 phelpe holder 4 Women's Fleece Pullover 352555-1972 3525551811 lewissa 125pass 5 Children's Beachcomber Sandals 7615553485 7615553319 jamest nok Stell 6 Boy's Surf Shorts 7 ORDER SOURCE Girl's Soccer Tee OS ID OS DESC ORDER LINE Number String OD INV 10 Winter 2005 OL QUANTITY 1 2 006 Number Number 3 Summer 2006 4 Outdoor 2006 11 14 5 Children's 2006 2 19 1 6 Werb Site 3 24 1 26 ORDERS 4 12 OID O DATE OS ID OMITH MICHID 2 5 8 1 Number Number Datume 1 57297/2006 ed 2 15 13 1 572372.000 2 CE 6 6 1 5 2 3 571/2006 2 2 6 17 3 4 5/11/2000 3 3 5 6/01/2006 CC 4 6 SHIPMENT 6 K6/01/2006 4 SHIP ID SHIP DATE EXPECTED CATEGORY Number CAT ID CAT DESC 1 GTX 2006 Number 2 11/15/2006 1 Women Cloth 0675/2006 12 Children Clothing 19 06/25/2006 2 Men's Clothing 5 007157200 4 Outdoor SL DATE RECEIVED Date/Time 09/10/2006 09/10/2006 INVENTORY INVID ITEM ID Number Number COLOR INV SIZE String INVQOH Number SHIPMENT LINE SHIP ID INV ID Number Number 1 1 2 2 2 3 5 3 6 7 12 4 13 5 23 5 24 5 25 INV PRICE Number 25999 25999 2995 SL QUANTITY Number 25 25 25 200 200 200 100 100 50 100 100 Sky Blue Lht Grey Khan Khal 2 3 4 5 5 M 12 150 147 O 2 3 3 3 3 3 3 5 M 29.95 20795 29,95 7 08/15/2006 08725/2006 08/15/2006 08/15/2006 08/15/2006 Navy Navy Navy galant Erlant Lergant Royal Royal Royal Turquoise Toise Turquoise TURILOR 5 M L 5 M 5999 5995 113 135 16 182 O 124 112 121 111 10 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 121 148 COLOR COLOR String Sky Blue Let Grey Khaki Navy Royal Errplant Blue Red Spruce Turquoise Brght Pik White BRUK Bright Pink 5995 59.95 3599 15.99 15.99 150 1599 3599 15.99 15 19995 19923 209.95 134 4 4 4 5 5 5 9 5 5 5 5 1 1 1 1 6 6 6 7 2 > 72 1 10 11 12 1 s M L XL 5 M Spruce Spruce Spruce Spruce Blue 15.95 12 17 0 12 50 100 100 100 100 5 30 31 32 Eile White White White 1990 1990 19.99 L Figure 1-24 Clearwater Traders database (continued) Figure 1-24 Clearwater Traders database (continued)
