Comments (3)
Paul Buffa
Jun 28, 2023Ah, yes, this one is a bit confusing since there are multiple products that were launched on the same. This is more about testing out the syntax that uncovering true insights, though I noticing this is the data is certainly an A+ in my book.
The idea was to use a window function to find the first product by each category. You could use the row_number() function and partition by the products.Category and order by the products.Launch date. It would arbitrarily pick the first record in the database, which for this exercise is ok. But you could do something like use the first order date instead, which would be more meaningful.
Paul Buffa
Jun 28, 2023Very close! You could just remove the DISTINCT in the SELECT DISTINCT at the end and there's no need for the LEFT JOINs. A regular JOIN works fine.
Jun 28, 2023
Overall you did well on the assignment! Good job. You've completed the SQL course. We'll send you a certificate soon. We're first just going through all the assignments.