Question: Challenge #1 - Part 1 To measure your competency with the topics covered in the previous 3 lessons, let's work through a 5-part challenge that

 Challenge \#1 - Part 1 To measure your competency with thetopics covered in the previous 3 lessons, let's work through a 5-part

Challenge \#1 - Part 1 To measure your competency with the topics covered in the previous 3 lessons, let's work through a 5-part challenge that brings all of the concepts together. In this challenge, we will utilize the retail. products table. Complete each part in order as they progressively build on each other. You will see a column called sku in the retail. products table. This is retail jargon for a product code or internal name for a product. In different lessons or exercises, the field will sometimes be called , but know that the two fields are equivalent. To see the Task's Checks, Feedback, Expected and Actual Results, you may have to enlarge your results window. To see the Hints, you may have to condense the Task. Pull all of the products that are currently on markdown. In your results, include: - product_id - sku Run a SQL query to generate results - original_price - current_price - on_markdown Pull all of the products that are currently on markdown. In your results, include: - sku - hecks SQL Database Test Incomplete Part 1 Want a hint? - If a product is currently on markdown, there will be a for that product in the column

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!