please answer the first 20 questions, its fine if it takes longer, not due til december 2nd

Task: You are to write the SQL queries to fulfill requests or to answer the following questions. Place your answers in a Microsoft Word document and submit it to Canvas. 1. What is the neck size from the "MensSizes" table for Size 2X? 2. Show Bust, Waist, and Hips from the "WomenSizes" table for Size Small. 3. List all fields and all the records in the "Shirt" table. 4. List all fields for all the records in the "Pants" table that Type is Yoga. 5. Show Product No and StyleNo for all the records in the "Dress" table that ColorNo is 143 and Size is Xsmall 6. Show Product No StyleNo, Size, and ColorNo for all the records in the "Dress" table where Sleeves is None. 7. Show Product No and StyleNo for all the records in the "Skirt" table that ColorNo is 122 and Size is Large 8. What Color is CollorNo 128? 9. Show Product No and Quantity for all the records in the "Inventory" table that quantity is equal to or greater than fifty (50) 10. List all fields for all the records in the "Pants" table that Size is Large or Xlarge. 11. Show ProductNo, Quantity, and Price for all records in the "Inventory" table that Price is less than $20 from lowest to highest 12. What unique styles of skirts are there that Size is Xsmall? 13. Show Product No StyleNo, and Sleeves from the "Dress" and "Color" tables for all the records that Color Name is Red and Size is Small 14. What Robin Blue hats are there? Shows all fields in the "Hat" table 15. Show Product No (either table), Sleeves, ColorNo, Size, and Price from the Inventory and "Shirt" for all the records that Category is Mens Type is Polo, and Size is 3X 16. Show Product No (either table), Category, Size, Quantity, and Price from the "Inventory and "Pants" tables for all the records that Type is Shorts and Quantity is greater tha sorted by Quantity from highest to lowest 17. What is the ProductNo. Quantity, and Cost for all records from the "Inventory" and "Hat" tables for all the records that are Womens Flex visors? 18. Show ProductNo and TotalCost (computed as Quantity times Cost rounded to 0 decimal places) from the "Inventory" and "Pant" tables for all Yoga Pants that Category is Mens and Size is Medium 19. Show ProductNo. Quantity, and Price from the "Inventory," "Color," and "Shirt tables for all records for Orange Rugby Shirts that Category is Womens and Size is Large, 20. Show ProductNo, Quantity, and Price from the "Inventory," "Skirt," and "Style" tables for all records that StyleName is Tunic and Size is Xsmal. SQL Project A&L is a company that sells inexpensive, activewear clothing. A&L has a relational database that stores data on their inventory. The following are the descriptions some of the tables and sample data (" denotes primary keys) Table Name: Field Name * Product No Quantity Cost Price Inventory Data Type Short Text Number Currency Currency Field Size Data Items 6 Ranges From 000001 to 999999 Integer $2.82 to 541 59 $6.99 to $99.99 Cost Price Inventory Table Sample Data Product No Quantity 230754 359841 423222 3 10 8 $37.50 $27.00 $18.15 $79.99 $54.99 $39.99 Table Name Field Name *Product No Category Type Sleeves Size ColorNo Shirt Data Type Short Text Short Text Short Text Short Text Short Text Short Text Field Size Data Items 6 Ranges From 000001 to 999999 6 Mens, Womens 7 Rugby Polo T-Shirt 5 Long. Short 6 Xsmall, Small Medium, Large, Xlarge, 2X, 3X 3 121, 125, ef Shirt Table Sample Data ColorNo Product No 230754 245769 Category Type Mens Rugby Womens T-Shirt Sleeves Size Long Xlarge Short Large 110 130 Table Name: Field Name *ProductNo Category Type Size ColorNo Pants Field Data Type Size Short Text Short Text Short Text Short Text Short Text Data Items 6 Ranges From 000001 to 999999 6 Mens, Womens 6 Sweats, Lounge, Yoga, Shorts 6 Xsmall, Small, Medium, Large, Xlarge, 2X, 3X 3 121, 125, etc. Pants Table Sample Data Product No 359841 389147 Category Womens Mens Type Yoga Sweats Size Medium Large ColorNo 157 128 Table Name: Field Name *ProductNo StyleNo Sleeves Size ColorNo Dress Data Type Short Text Short Text Short Text Short Text Short Text Field Size Data Items 6 Ranges From 000001 to 999999 201 to 99 9 Long, Midrange Short None 6 Xsmall Small, Medium, Large, Xlarge, 2X3X 3121, 125, etc... ColorNo Dress Table Sample Data Product No StyleNo 412865 457681 Sleeves 5 None 36 Long Size Large Xlarge 123 101 Table Name Field Name Product No StyleNo Size ColorNo Skirt Data Type Short Text Short Text Short Text Short Text Field Size Data Items 6 Ranges From 000001 to 999999 201 to 99 6Xsmall, Small, Medium, Large, Xlarge, 2X, 3X 3 121, 125, etc.. Skirt Table Product No 546111 StyleNo Sleeves Color No Size Medium 4 112 StyleNo Sleeves Skirt Table Product No 546111 524774 ColorNo 4 24 Size Medium Large 112 134 Table Name: Field Name *ProductNo Category Type Sizing Color No Hat Field Data Type Size Short Text Short Text Short Text Short Text Short Text Data Items 6 Ranges From 000001 to 999999 6 Mens Womens 6 Baseball, Bucket, Knit, Visor 9 Adjustable, Flex, Fits Most 3 121, 125, etc... Hat Table Sample Data Product No 642155 608445 Category Type Mens Baseball Womens Visor Sizing ColorNo Adjustable 144 Flex 149 Table Name: Field Name *Color No Color Name Color Data Type Short Text Short Text Field Size Data Items 3 Ranges from 100 to 185 20 Red Light Red, Dark Red, etc... Color Table Sample Data ColorNo 100 103 105 ColorName Dark Red Yellow Green Table Name: Field Name *StyleNo StyleName Style Data Type Short Text Short Text Field Size Data Items 21 to 99 20 A-Line, Asymmetrical Sheath, etc... Style Table Sample Data StyleNo StyleName 4 Wrap 5 Halter Table Name: Field Name *StyleNo StyleName Style Data Type Short Text Short Text Field Size Data Items 21 to 99 20 A-Line, Asymmetrical, Sheath, etc.. Style Table Sample Data StyleNo StyleName 4 Wrap 5 Halter Table Name: Field Name Size Neck Chest Waist Men Sizes Data Type Field Size Data Items Short Text 6 Xsmall. Small, Medium, Large, Xlarge, 2X, 3X Short Text 9 13-13.5, 14-14.5. etc... Short Text 5. 38-40, 42-44, etc... Short Text 5 34-36, 38-40, etc... MenSizes Table Sample Data Size Neck Xsmall 13-13.5 Small 14-14.5 Chest 30-32 34-36 Waist 26-28 30-32 SQL Project Table Name Field Name *Size US Size Bust Waist Hips Women Sizes Data Type Field Size Data Items Short Text 6 Xsmall, Small, Medium, Large, Xlarge, 2X, 3X Short Text 50/2, 4/6, etc Short Text 9 31-33, 34-34.5. etc... Short Text 9 23-24.5 25.5-26.5. etc. Short Text 933.5-35, 36-37 etc. Women Sizes Table Sample Data Size US Size Medium 8/10 Large 12/14 Bust 35.5-38 38.5-42 Waist 29.5-32 33-36,5 Hips 39-41 41-44