sql
sql
sql
sql
sql
sql
sql
sql
sql
sql
Comments (3)
Paul Buffa
Jun 27, 2023Note, that using date_part instead of date_trunc means you'll aggregate months across years. The prompt was a bit ambiguous, so this is still correct.
Paul Buffa
Jun 27, 2023Good job on this! The only thing here is that you don't need the DISTINCT in your SELECT.
Jun 27, 2023
Overall you did well on the assignment. Congrats! You've completed the SQL course. We'll send you a certificate soon. (First we're just going through all the assignments.)
© 2026 Observable, Inc.