Completed
Incomplete
Not Attended
Share
Aurora Fashion Store is a trendy retail outlet that maintains a comprehensive
product catalog. Each product record contains product ID, name, category, price, and discount
percent. The store manager wants to prepare the billing system for customers by calculating
discounted prices, converting prices to integers for easy payment, and rounding off prices to
two decimal places for receipts. Your role is to write SQL queries using
Question - 1Calculate final price after discount and convert to integer (use CAST)
Question - 2Round the final price to nearest two decimals.
Code Editor
Table Name: fashion_products
| product_id | product_name | category | price | discount_percent |
|---|---|---|---|---|
| 1 | T-Shirt | Clothing | 25.00 | 10.00 |
| 2 | Jeans | Clothing | 50.00 | 15.00 |
| 3 | Sneakers | Footwear | 75.00 | 20.00 |
| 4 | Jacket | Clothing | 100.00 | 25.00 |
| 5 | Hat | Accessories | 15.00 | 5.00 |
>>> Submit Your Query to validate