Need help writing quarries
- Show ProductNo and Quantity for all the records in the Inventory table that quantity is equal to or greater than fifty (50).
- List all fields for all the records in the Pants table that Size is Large or Xlarge.
- Show ProductNo, Quantity, and Price for all records in the Inventory table that Price is less than $20 from lowest to highest.
- What unique styles of skirts are there that Size is Xsmall?
Field Name Data Type Field Size Data Items Table Name: Color Table Sample Data ColorNo Inventory *ProductNo ColorName Short Text 6 Ranges From 000001 to 999999 Field Name Data Type Field Size Data Items 100 Dark Red 2 *ProductNo Short Text 6 Ranges From 000001 to 999999 StyleNo Sleeves Short Text Short Text 103 Yellow 9 Quantity Number Integer 01 to 99 Long, Midrange, Short, None Xsmall, Small, Medium, Large, Xlarge, 2X, 3X 121, 125, etc 105 Green Size Short Text 6 Cost Currency $2.82 to $41.59 $6.99 to $99.99 ColorNo Short Text 3 Currency Table Name: Price Style Dress Table Sample Data Field Name Data Type Field Size Data Items Inventory Table Sample Data ProductNo ProductNo StyleNo Sleeves Size ColorNo *StyleNo Short Text 2 1 to 99 Quantity Cost Price 412865 5 None Large 123 StyleName Short Text 20 A-Line, Asymmetrical, Sheath, etc.. 230754 3 $37.50 $79.99 457681 36 Long Xlarge 101 359841 10 $27.00 $54.99 Style Table Sample Data StyleNo 423222 StyleName $18.15 $39.99 Table Name: Field Name Skirt Data Type Field Size 4 Data Items Wrap Table Name: Shirt 5 *ProductNo Halter Short Text Ranges From 000001 to 999999 6 Field Size Data Items Field Name *ProductNo Data Type Short Text Short Text 2 01 to 99 Table Name: Ranges From 000001 to 999999 StyleNo Size ColorNo Mensizes Data Type Short Text 6 Xsmall, Small, Medium, Large, Xlarge, 2X, 3X 121, 125, etc Field Name Field Size Data Items Short Text Short Text 3 *Size Short Text 6Xsmall, Small, Medium, Large, Xlarge, 2X, 3X Short Text Category Type Sleeves Size Neck Short Text 9 Short Text 6 Mens, Womens 7 Rugby, Polo, T-Shirt 5 Long, Short 6 Xsmall, Small, Medium, Large, Xlarge, 2X, 3X 3121, 125, etc. Skirt Table ProductNo StyleNo Sleeves Size ColorNo Chest Short Text 5 13-13.5, 14-14.5, etc. 38-40, 42-44, etc. 34-36, 38-40, etc. Short Text Short Text 546111 4 Medium 112 Short Text Waist 5 ColorNo 524774 24 Large 134 Shirt Table Sample Data Men Sizes Table Sample Data Size Neck Chest Waist Table Name: Hat Xsmall 13-13.5 30-32 26-28 Field Name Data Type Field Size ProductNo Category Data Items Sleeves Type Size ColorNo Small 14-14.5 34-36 30-32 *ProductNo Short Text 6 Ranges From 000001 to 999999 230754 Mens 110 Rugby T-Shirt Long Short Xlarge Large 245769 Womens 6 Category Short Text 130 Short Text 6 Mens, Womens Baseball, Bucket, Knit, Visor Adjustable, Flex, Fits Most 121, 125, etc.. Table Name: Pants Type Sizing ColorNo Short Text 9 Table Name: Field Name Field Size Data Items Short Text 3 Data Type Short Text Women Sizes Data Type Field Name Field Size Data Items *ProductNo 6 Ranges From 000001 to 999999 "Size Short Text Xsmall, Small, Medium, Large, Xlarge, 2X, 3X Category Short Text 6 Hat Table Sample Data US Size Short Text Type Short Text Mens, Womens Sweats, Lounge, Yoga, Shorts Xsmall, Small, Medium, Large, Xlarge, 2X, 3X 121, 125, etc. Bust Short Text 50/2, 4/6, etc 9 31-33, 34-34.5, etc 9 23-24.5, 25.5-26.5, etc Size Short Text 6 ProductNo Category Sizing ColorNo Waist Short Text ColorNo Short Text 3 Type Baseball 642155 Mens Adjustable 144 Hips Short Text 9 33.5-35, 36-37. etc 608445 Womens Visor Flex 149 Pants Table Sample Data Table Name: Color Bust Waist Hips WomenSizes Table Sample Data Size US Size Medium 8/10 Large ProductNo Size ColorNo Field Name Data Type Field Size Data Items 35.5-38 29.5-32 39-41 359841 Category Womens Mens Type Yoga Sweats Medium 157 *ColorNo Short Text 38.5-42 Ranges from 100 to 185 3 12/14 33-36.5 41-44 389147 Large 128 ColorName Short Text 20 Red, Light Red, Dark Red, etc... Table Name: Dress
