Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

9 Add the following item to the Products table: ProductiD ProductName SupplierlD CategorylD 78 10 Find all the products that are listed in Category 3

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
9 Add the following item to the Products table: ProductiD ProductName SupplierlD CategorylD 78 10 Find all the products that are listed in Category 3 Join the Categories table with the Products table on th and then Unit Price Silver Sprinkles 17 3 6-1 oz jar 6.79 e CategoryID field, select only records that are in Category 3, list the CategoryName, ProductID, ProductName, Unit, and Price for each item. The first three results might look something like this (but you will have more than three records!) CategoryName ProductID ProductName Confections 16 19 20 Pavlova Teatime Chocolate Biscuits Sir Rodney's Marmalade Unit 32-500 g boxes 10 boxes x 12 pieces 30 gift boxes Price 17.45 9.2 81 Confections Confections Copy your SQL query and all the records shown as results and then paste them into your word processor. Number of Records: 77 Price 18 19 10 ProductID ProductName SupplierID CategoryID Unit Chais Chang Aniseed Syrup Chef Anton's Cajun Seasoning Chef Anton's Gumbo Mix Grandma's Boysenberry Spread Uncle Bob's Organic Dried Pears 10 boxes x 20 bags 24 12 oz bottles 12 - 550 ml bottles 48 6 oz jars 36 boxes 12-8 oz jars 21.35 25 30 3 12 1 lb pkgs CategoryID CategoryName Beverages Condiments Confections Dairy Products Grains/Cereals Meat/Poultry Produce Seafood Description Soft drinks, coffees, teas, beers, and ales Sweet and savory sauces, relishes, spreads, and seasonings Desserts, candies, and sweet breads Cheeses Breads, crackers, pasta, and cereal Prepared meats Dried fruit and bean curd Seaweed and fish 3 5 6 7 8 Using SQL queries. Please solve number 9 and 10. More important is number 10. Thank you

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

MongoDB Applied Design Patterns Practical Use Cases With The Leading NoSQL Database

Authors: Rick Copeland

1st Edition

1449340040, 978-1449340049

More Books

Students also viewed these Databases questions