Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started