Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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)
Challenge \#1 - Part 5 Determine what the sale price would be for each item if the Marketing team went V off the rails and implemented a sale for 35% off the original price of all items! Once again, add this new column onto the end of your existing query and name it discount_ 35 . Not quite. Edit your query and try again! Checks SQL Database Test incomplete Part 5 Feedback (?) The following error was generated: ERROR: relation "your_table_name" does not exist LINE 2: FROM your_table_name; The wrong headers were returned. Some expected rows were missing (shown in red below). Run a SQL query to generate results

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Linked Data A Geographic Perspective

Authors: Glen Hart, Catherine Dolbear

1st Edition

1000218910, 9781000218916

More Books

Students also viewed these Databases questions

Question

1. Traditional and modern methods of preserving food Articles ?

Answered: 1 week ago

Question

What is sociology and its nature ?

Answered: 1 week ago

Question

What is liquidation ?

Answered: 1 week ago

Question

Explain the different types of Mergers.

Answered: 1 week ago

Question

Provide examples of KPIs in Human Capital Management.

Answered: 1 week ago

Question

What are OLAP Cubes?

Answered: 1 week ago