- The Query On The Left Is Incorrect Please Help 1 (39.3 KiB) Viewed 29 times
The query on the left is incorrect. Please help.
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
The query on the left is incorrect. Please help.
The query on the left is incorrect. Please help.
Tools ps CENGAGE MINDTAP SQL Labs Challenge 1 3 S B Challenge #1 - Part 4 0:00 out of 1000 Checks Now that you have the discount pct.use your code from that calculation and multiply it by the original price to see if it matches the discount amount you calculated. Again, do this calculation in a new column and name the column check. Task Not quite. Edit your query and try again! SQL Database Test Incomplete Part 4 Feedback AT The wrong headers were returned. Some expected rows were missing (shown in red below). Some unexpected rows were returned. Expected Results product_id sku original price current price on ma SC- ALV 250 4/5 III 200 query.sql 1 select product_id, sku, original_price, current_price, 2 case when current price original price. 3 then '1' 4 else 0 5 end on markdown, (original_price-current_price) 6 as discount amount, 7 round (((1.0 8 as discount_pct 9 from retail.products 10 where current price original_price; 11 67 68 SQL Viewer product id sku original price current price on markdown discount amount 69 sql101 SC BLK 250 8 SC- BLK 250 8.5 SC- BEK- 250 Q Search this course original_price-current_price. 1.0)/original 200 200 200 50 50 50 X Run
Tools ps CENGAGE MINDTAP SQL Labs Challenge 1 3 S B Challenge #1 - Part 4 0:00 out of 1000 Checks Now that you have the discount pct.use your code from that calculation and multiply it by the original price to see if it matches the discount amount you calculated. Again, do this calculation in a new column and name the column check. Task Not quite. Edit your query and try again! SQL Database Test Incomplete Part 4 Feedback AT The wrong headers were returned. Some expected rows were missing (shown in red below). Some unexpected rows were returned. Expected Results product_id sku original price current price on ma SC- ALV 250 4/5 III 200 query.sql 1 select product_id, sku, original_price, current_price, 2 case when current price original price. 3 then '1' 4 else 0 5 end on markdown, (original_price-current_price) 6 as discount amount, 7 round (((1.0 8 as discount_pct 9 from retail.products 10 where current price original_price; 11 67 68 SQL Viewer product id sku original price current price on markdown discount amount 69 sql101 SC BLK 250 8 SC- BLK 250 8.5 SC- BEK- 250 Q Search this course original_price-current_price. 1.0)/original 200 200 200 50 50 50 X Run