developing queries and databse design using MySQL workbench
Budget: $25 – $60 USD
here is an example of one query needed to be made.
Part 2: Queries
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 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 that’s calculated from the previous two columns
discount_price A column that’s 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.
Part 2: Queries
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 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 that’s calculated from the previous two columns
discount_price A column that’s 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.