Answered step by step
Verified Expert Solution
Question
1 Approved Answer
xpected Results product_id sku original_price current_price on_markdown discount_amount discount_pct check discount_35 67 SC-BLK-8 250 200 1 50 0.20 50.00 162.50 68 SC-BLK-8.5 250 200 1
xpected Results
product_id | sku | original_price | current_price | on_markdown | discount_amount | discount_pct | check | discount_35 |
---|---|---|---|---|---|---|---|---|
67 | SC-BLK-8 | 250 | 200 | 1 | 50 | 0.20 | 50.00 | 162.50 |
68 | SC-BLK-8.5 | 250 | 200 | 1 | 50 | 0.20 | 50.00 | 162.50 |
69 | SC-BLK-9 | 250 | 200 | 1 | 50 | 0.20 | 50.00 | 162.50 |
70 | SC-BLK-9.5 | 250 | 200 | 1 | 50 | 0.20 | 50.00 | 162.50 |
71 | SC-BLK-10 | 250 | 200 | 1 | 50 | 0.20 | 50.00 | 162.50 |
72 | SC-BLK-10.5 | 250 | 200 | 1 | 50 | 0.20 | 50.00 | 162.50 |
73 | SC-BLK-11 | 250 | 200 | 1 | 50 | 0.20 | 50.00 | 162.50 |
74 | SC-BLK-11.5 | 250 | 200 | 1 | 50 | 0.20 | 50.00 | 162.50 |
75 | SC-BLK-12 | 250 | 200 | 1 | 50 | 0.20 | 50.00 | 162.50 |
76 | SC-BLK-12.5 | 250 | 200 | 1 | 50 | 0.20 | 50.00 | 162.50 |
77 | SC-BLK-13 | 250 | 200 | 1 | 50 | 0.20 | 50.00 | 162.50 |
78 | SC-BRN-8 | 250 | 200 | 1 | 50 | 0.20 | 50.00 | 162.50 |
79 | SC-BRN-8.5 | 250 | 200 | 1 | 50 | 0.20 | 50.00 | 162.50 |
80 | SC-BRN-9 | 250 | 200 | 1 | 50 | 0.20 | 50.00 | 162.50 |
81 | SC-BRN-9.5 | 250 | 200 | 1 | 50 | 0.20 | 50.00 | 162.50 |
82 | SC-BRN-10 | 250 | 200 | 1 | 50 | 0.20 | 50.00 | 162.50 |
83 | SC-BRN-10.5 | 250 | 200 | 1 | 50 | 0.20 | 50.00 | 162.50 |
84 | SC-BRN-11 | 250 | 200 | 1 | 50 | 0.20 | 50.00 | 162.50 |
85 | SC-BRN-11.5 | 250 | 200 | 1 | 50 | 0.20 | 50.00 | 162.50 |
86 | SC-BRN-12 | 250 | 200 | 1 | 50 | 0.20 | 50.00 | 162.50 |
87 | SC-BRN-12.5 | 250 | 200 | 1 | 50 | 0.20 | 50.00 | 162.50 |
88 | SC-BRN-13 | 250 | 200 | 1 | 50 | 0.20 | 50.00 | 162.50 |
89 | SC-BLU-8 | 250 | 200 | 1 | 50 | 0.20 | 50.00 | 162.50 |
90 | SC-BLU-8.5 | 250 | 200 | 1 | 50 | 0.20 | 50.00 | 162.50 |
91 | SC-BLU-9 | 250 | 200 | 1 | 50 | 0.20 | 50.00 | 162.50 |
92 | SC-BLU-9.5 | 250 | 200 | 1 | 50 | 0.20 | 50.00 | 162.50 |
93 | SC-BLU-10 | 250 | 200 | 1 | 50 | 0.20 | 50.00 | 162.50 |
94 | SC-BLU-10.5 | 250 | 200 | 1 | 50 | 0.20 | 50.00 | 162.50 |
95 | SC-BLU-11 | 250 | 200 | 1 | 50 | 0.20 | 50.00 | 162.50 |
96 | SC-BLU-11.5 | 250 | 200 | 1 | 50 | 0.20 | 50.00 | 162.50 |
97 | SC-BLU-12 | 250 | 200 | 1 | 50 | 0.20 | 50.00 | 162.50 |
98 | SC-BLU-12.5 | 250 | 200 | 1 | 50 | 0.20 | 50.00 | 162.50 |
99 | SC-BLU-13 | 250 | 200 | 1 | 50 | 0.20 | 50.00 | 162.50 |
133 | CH-BLK-6 | 200 | 160 | 1 | 40 | 0.20 | 40.00 | 130.00 |
134 | CH-BLK-6.5 | 200 | 160 | 1 | 40 | 0.20 | 40.00 | 130.00 |
135 | CH-BLK-7 | 200 | 160 | 1 | 40 | 0.20 | 40.00 | 130.00 |
136 | CH-BLK-7.5 | 200 | 160 | 1 | 40 | 0.20 | 40.00 | 130.00 |
137 | CH-BLK-8 | 200 | 160 | 1 | 40 | 0.20 | 40.00 | 130.00 |
138 | CH-BLK-8.5 | 200 | 160 | 1 | 40 | 0.20 | 40.00 | 130.00 |
139 | CH-BLK-9 | 200 | 160 | 1 | 40 | 0.20 | 40.00 | 130.00 |
140 | CH-BLK-9.5 | 200 | 160 | 1 | 40 | 0.20 | 40.00 | 130.00 |
141 | CH-BLK-10 | 200 | 160 | 1 | 40 | 0.20 | 40.00 | 130.00 |
142 | CH-BLK-10.5 | 200 | 160 | 1 | 40 | 0.20 | 40.00 | 130.00 |
143 | CH-BLK-11 | 200 | 160 | 1 | 40 | 0.20 | 40.00 | 130.00 |
144 | CH-BRN-6 | 200 | 160 | 1 | 40 | 0.20 | 40.00 | 130.00 |
145 | CH-BRN-6.5 | 200 | 160 | 1 | 40 | 0.20 | 40.00 | 130.00 |
146 | CH-BRN-7 | 200 | 160 | 1 | 40 | 0.20 | 40.00 | 130.00 |
147 | CH-BRN-7.5 | 200 | 160 | 1 | 40 | 0.20 | 40.00 | 130.00 |
148 | CH-BRN-8 | 200 | 160 | 1 | 40 | 0.20 | 40.00 | 130.00 |
149 | CH-BRN-8.5 | 200 | 160 | 1 | 40 | 0.20 | 40.00 | 130.00 |
150 | CH-BRN-9 | 200 | 160 | 1 | 40 | 0.20 | 40.00 | 130.00 |
151 | CH-BRN-9.5 | 200 | 160 | 1 | 40 | 0.20 | 40.00 | 130.00 |
152 | CH-BRN-10 | 200 | 160 | 1 | 40 | 0.20 | 40.00 | 130.00 |
153 | CH-BRN-10.5 | 200 | 160 | 1 | 40 | 0.20 | 40.00 | 130.00 |
154 | CH-BRN-11 | 200 | 160 | 1 | 40 | 0.20 | 40.00 | 130.00 |
155 | CH-TAN-6 | 200 | 160 | 1 | 40 | 0.20 | 40.00 | 130.00 |
156 | CH-TAN-6.5 | 200 | 160 | 1 | 40 | 0.20 | 40.00 | 130.00 |
157 | CH-TAN-7 | 200 | 160 | 1 | 40 | 0.20 | 40.00 | 130.00 |
158 | CH-TAN-7.5 | 200 | 160 | 1 | 40 | 0.20 | 40.00 | 130.00 |
159 | CH-TAN-8 | 200 | 160 | 1 | 40 | 0.20 | 40.00 | 130.00 |
160 | CH-TAN-8.5 | 200 | 160 | 1 | 40 | 0.20 | 40.00 | 130.00 |
161 | CH-TAN-9 | 200 | 160 | 1 | 40 | 0.20 | 40.00 | 130.00 |
162 | CH-TAN-9.5 | 200 | 160 | 1 | 40 | 0.20 | 40.00 | 130.00 |
163 | CH-TAN-10 | 200 | 160 | 1 | 40 | 0.20 | 40.00 | 130.00 |
164 | CH-TAN-10.5 | 200 | 160 | 1 | 40 | 0.20 | 40.00 | 130.00 |
165 | CH-TAN-11 | 200 | 160 | 1 | 40 | 0.20 | 40.00 | 130.00 |
(66 rows) |
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