Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Do the following in MySQL if possible, and copy-and-paste the commands into Blackboard or put screen shots into a Word document and attach that to

image text in transcribed

Do the following in MySQL if possible, and copy-and-paste the commands into Blackboard or put screen shots into a Word document and attach that to Blackboard. If you do not have access to MySQL you may type the commands directly into Blackboard, but your chances of making a mistake without testing in MySQL are high Helpful commands: show tables; describe ; Don't Using the data in the ZAGI database, provide the SQL commands that would produce a list of data satisfying each of the following requirements. forget your semicolons! Example: Retrieve all of the fields in the product table. Answer: SELECT FROM product; 1. Retrieve all of the records for customer id 1-2-333 in the salestransaction table. 2. Query the store table to retrieve the store id and zip code for store id S2. 3. From the product table, retrieve all of the products with "Tent" in their name, their product price, and what their product price would be at an 8% discount. 4. From the product table, retrieve the names of all products sold by vendor id MK. 5. Retrieve a list of store ids from the salestransaction table, with none of the ids repeated 6. Retrieve a list of product names and their prices from the product table, listed alphabetically by name. 7. Retrieve the product id, product name, and price for each product in the FW product category, sorted by price from most expensive to least expensive. 8. Retrive the product id, product name, category id, and product price for each product, sorted by category id and, within the same category id, by product price

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

Database And Expert Systems Applications 24th International Conference Dexa 2013 Prague Czech Republic August 2013 Proceedings Part 1 Lncs 8055

Authors: Hendrik Decker ,Lenka Lhotska ,Sebastian Link ,Josef Basl ,A Min Tjoa

2013 Edition

3642402844, 978-3642402845

More Books

Students also viewed these Databases questions

Question

What are the objectives of performance appraisal ?

Answered: 1 week ago

Question

State the uses of job description.

Answered: 1 week ago

Question

Explain in detail the different methods of performance appraisal .

Answered: 1 week ago