Question
Challenge #1 - Part 4 Task Now that you have the discount_pct, use your code from that calculation and multiply it by the original_price to
Challenge #1 - Part 4 Task 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. Want a hint? For this new column, use the same code that you used for the last column, but multiply it by the original_price field. Remember, you cannot reference a column name (like discount_amount) within the same query, so you will have to copy the calculation you used previously. Be careful of parentheses! 4/5 567843 AS discount_pct from retail.products Where current_price < original_price product_id sku original_price current_price on_markdown discount_amount discount_pct 67 SC-BLK-8 2
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
.
I need step-by-step instructions to know how to add the new column check as asked in Challenge #1 - part 4.
- SQL Viewer
product_id | sku | original_price | current_price | on_markdown | discount_amount | discount_pct |
---|---|---|---|---|---|---|
67 | SC-BLK-8 | 250 | 200 | 1 | f | 0.20 |
68 | SC-BLK-8.5 | 250 | 200 | 1 | f | 0.20 |
69 | SC-BLK-9 | 250 | 200 | 1 | f | 0.20 |
70 | SC-BLK-9.5 | 250 | 200 | 1 | f | 0.20 |
71 | SC-BLK-10 | 250 | 200 | 1 | f | 0.20 |
72 | SC-BLK-10.5 | 250 | 200 | 1 | f | 0.20 |
73 | SC-BLK-11 | 250 | 200 | 1 | f | 0.20 |
74 | SC-BLK-11.5 | 250 | 200 | 1 | f | 0.20 |
75 | SC-BLK-12 | 250 | 200 | 1 | f | 0.20 |
76 | SC-BLK-12.5 | 250 | 200 | 1 | f | 0.20 |
77 | SC-BLK-13 | 250 | 200 | 1 | f | 0.20 |
78 | SC-BRN-8 | 250 | 200 | 1 | f | 0.20 |
79 | SC-BRN-8.5 | 250 | 200 | 1 | f | 0.20 |
80 | SC-BRN-9 | 250 | 200 | 1 | f | 0.20 |
81 | SC-BRN-9.5 | 250 | 200 | 1 | f | 0.20 |
82 | SC-BRN-10 | 250 | 200 | 1 | f | 0.20 |
83 | SC-BRN-10.5 | 250 | 200 | 1 | f | 0.20 |
84 | SC-BRN-11 | 250 | 200 | 1 | f | 0.20 |
85 | SC-BRN-11.5 | 250 | 200 | 1 | f | 0.20 |
86 | SC-BRN-12 | 250 | 200 | 1 | f | 0.20 |
87 | SC-BRN-12.5 | 250 | 200 | 1 | f | 0.20 |
88 | SC-BRN-13 | 250 | 200 | 1 | f | 0.20 |
89 | SC-BLU-8 | 250 | 200 | 1 | f | 0.20 |
90 | SC-BLU-8.5 | 250 | 200 | 1 | f | 0.20 |
91 | SC-BLU-9 | 250 | 200 | 1 | f | 0.20 |
92 | SC-BLU-9.5 | 250 | 200 | 1 | f | 0.20 |
93 | SC-BLU-10 | 250 | 200 | 1 | f | 0.20 |
94 | SC-BLU-10.5 | 250 | 200 | 1 | f | 0.20 |
95 | SC-BLU-11 | 250 | 200 | 1 | f | 0.20 |
96 | SC-BLU-11.5 | 250 | 200 | 1 | f | 0.20 |
97 | SC-BLU-12 | 250 | 200 | 1 | f | 0.20 |
98 | SC-BLU-12.5 | 250 | 200 | 1 | f | 0.20 |
99 | SC-BLU-13 | 250 | 200 | 1 | f | 0.20 |
133 | CH-BLK-6 | 200 | 160 | 1 | f | 0.20 |
134 | CH-BLK-6.5 | 200 | 160 | 1 | f | 0.20 |
135 | CH-BLK-7 | 200 | 160 | 1 | f | 0.20 |
136 | CH-BLK-7.5 | 200 | 160 | 1 | f | 0.20 |
137 | CH-BLK-8 | 200 | 160 | 1 | f | 0.20 |
138 | CH-BLK-8.5 | 200 | 160 | 1 | f | 0.20 |
139 | CH-BLK-9 | 200 | 160 | 1 | f | 0.20 |
140 | CH-BLK-9.5 | 200 | 160 | 1 | f | 0.20 |
141 | CH-BLK-10 | 200 | 160 | 1 | f | 0.20 |
142 | CH-BLK-10.5 | 200 | 160 | 1 | f | 0.20 |
143 | CH-BLK-11 | 200 | 160 | 1 | f | 0.20 |
144 | CH-BRN-6 | 200 | 160 | 1 | f | 0.20 |
145 | CH-BRN-6.5 | 200 | 160 | 1 | f | 0.20 |
146 | CH-BRN-7 | 200 | 160 | 1 | f | 0.20 |
147 | CH-BRN-7.5 | 200 | 160 | 1 | f | 0.20 |
148 | CH-BRN-8 | 200 | 160 | 1 | f | 0.20 |
149 | CH-BRN-8.5 | 200 | 160 | 1 | f | 0.20 |
150 | CH-BRN-9 | 200 | 160 | 1 | f | 0.20 |
151 | CH-BRN-9.5 | 200 | 160 | 1 | f | 0.20 |
152 | CH-BRN-10 | 200 | 160 | 1 | f | 0.20 |
153 | CH-BRN-10.5 | 200 | 160 | 1 | f | 0.20 |
154 | CH-BRN-11 | 200 | 160 | 1 | f | 0.20 |
155 | CH-TAN-6 | 200 | 160 | 1 | f | 0.20 |
156 | CH-TAN-6.5 | 200 | 160 | 1 | f | 0.20 |
157 | CH-TAN-7 | 200 | 160 | 1 | f | 0.20 |
158 | CH-TAN-7.5 | 200 | 160 | 1 | f | 0.20 |
159 | CH-TAN-8 | 200 | 160 | 1 | f | 0.20 |
160 | CH-TAN-8.5 | 200 | 160 | 1 | f | 0.20 |
161 | CH-TAN-9 | 200 | 160 | 1 | f | 0.20 |
162 | CH-TAN-9.5 | 200 | 160 | 1 | f | 0.20 |
163 | CH-TAN-10 | 200 | 160 | 1 | f | 0.20 |
164 | CH-TAN-10.5 | 200 | 160 | 1 | f | 0.20 |
165 | CH-TAN-11 | 200 | 160 | 1 | f | 0.20 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started