Write a SELECT statement that returns these column names and data from the Products table: product_name The product_name
Posted: Mon Jul 11, 2022 9:54 am
Write a SELECT statement that returns these column names anddata 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 twocolumns
discount_price A column that’s calculated from the previousthree columns
Round the discount_amount and discount_price columns to twodecimal places. Sort the result set by the discount_price column indescending sequence. Use the LIMIT clause so the result setcontains only the first five rows.
Submit a screenshot.
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 twocolumns
discount_price A column that’s calculated from the previousthree columns
Round the discount_amount and discount_price columns to twodecimal places. Sort the result set by the discount_price column indescending sequence. Use the LIMIT clause so the result setcontains only the first five rows.
Submit a screenshot.