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 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
Get step-by-step solutions from verified subject matter experts
