Comments (5)
Paul Buffa
Jun 27, 2023Great job doing the variations!
Paul Buffa
Jun 27, 2023You'll want to use the count of orders vs. the count of items here. You'll notice the results change. That's because order items is going to duplicate the orders ids by the number of items ordered, so it's going to inflate orders that had more than one items.
Paul Buffa
Jun 27, 2023This is absolutely correct, just want to note a more common approach to a moving average would be to anchor the date in the middle, so that would be 14 days preceding and 14 days following. This is correct though!
Paul Buffa
Jun 27, 2023I like this approach! It groups together products that launched the same day. Well done! Could be cool to include those product names with something like a group_concat()
Paul Buffa
Jun 27, 2023Great job on all the prompts and completing the bonus points! You've completed the course assignment. We'll send over the certification soon. We're just first going through all the assignments. Thanks!