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.
Write a SELECT statement that returns these column names and data from the Products table: product_name The product_name
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am