Question: Using the My Guitar Shop database you installed in Module 1, develop the following queries. SUBMIT A SCREENSHOT OF EACH STEP. Write a SELECT statement

Using the My Guitar Shop database you installed in Module 1, develop the following queries. SUBMIT A SCREENSHOT OF EACH STEP.

  1. Write a SELECT statement that returns these column names and data from the Products table:

    product_name The product_name column

    list_price The list_price column

    discount_percent The discount_percent column

    discount_amount A column thats calculated from the previous two columns

    discount_price A column thats calculated from the previous three columns

    Round the discount_amount and discount_price columns to two decimal places. Sort the result set by the discount_price column in descending sequence. Use the LIMIT clause so the result set contains only the first five rows. Submit a screenshot.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

MySQL Assignment Your Portfolio Project consists of two parts, a lesson learned reflection report and a database design and analysis project. Part 1: Lessons Learned and Reflection Write a 2- to...

Q:

Using the My Guitar Shop database you installed in Module 1 , develop the following queries. SUBMIT A SCREENSHOT OF EACH STEP. 1 . Write a SELECT statement that returns these column names and data...

Q:

Your Portfolio Project consists of two parts, a lesson learned reflection report and a database design and analysis project. Part 1 : Lessons Learned and Reflection Write a 2 - to 3 - page summary...

Q:

Using the My Guitar Shop database you installed in Module 1, develop the following queries. 1. Write a SELECT statement that returns four columns from the Products table: product_code, product_name,...

Q:

Using Joins Using the My Guitar Shop database you installed in Module 1 , develop the following queries. Write a SELECT statement that joins the Categories table to the Products table and returns...

Q:

Using the My Guitar Shop database you installed in Module 1 , develop the following queries. Write a SELECT statement that joins the Categories table to the Products table and returns these columns:...

Q:

Using the My Guitar Shop database you installed in Module 1 , develop the following queries. Write a SELECT statement that joins the Categories table to the Products table and returns these columns:...

Q:

Using the My Guitar Shop database you installed in Module 1 , develop the following queries. To test whether a table has been modified correctly as you do these exercises, you can write and run an...

Q:

Using the My Guitar Shop database you installed in Module 1 , develop the following queries. To test whether a table has been modified correctly as you do these exercises, you can write and run an...

Q:

Using the My Guitar Shop database you installed in Module 1 , develop the following queries. Write a SELECT statement that joins the Categories table to the Products table and returns these columns:...

Q:

The two dishes prepared by Common Bond will be designated as A and B. The costs of ingredients are $3 for dish A and $2 for dish B. There are up to 7 kitchen-hour available per day, and there are 400...

Q:

In a February 19, 2004, press release, the Securities and Exchange Commission described a number of fraudulent transactions that Enron executives concocted in an effort to meet the companys financial...

Q:

15. Which of the following changes needs heating? (a) gas to liquid (b) solid to liquid (c) liquid to solid (d) gas to solid

Q:

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

Q:

3. In this chapter, we talked about some of the challenges that todays organizations face, including work-life balance, sexual harassment, and communication technology. Does your organizationbe it a...

Q:

4. Its Tuesday, and you arrive home at 5:30 p.m. How do your housemates or family react? A. They say hello and discuss dinner plans. B. They act surprisedthey never know if youll be on time or not....

Q:

3. Which statement best describes what you usually do on vacation? A. I kick back, relax, and savor the time off. B. I check in with my organization at least once so that people know Im available. C....