sql
sql
sql
sql
sql
sql
sql
sql
sql
sql
sql
sql
Comments (3)
Paul Buffa
Jun 27, 2023Note, by grouping by date_part, you'll aggregating across years. If you use date_trunc, you'll retain the year information with the month. The prompt was a bit ambiguous, so this definitely counts!
Paul Buffa
Jun 27, 2023This is absolutely a correct solution, just want to note that a more common definition would put the anchor point in the center, so that would make it 14 days preceding and 14 days following. This is a correct solution though, just a less common one.
Paul Buffa
Jun 27, 2023I'm getting some errors for this one. Maybe something changed?
© 2026 Observable, Inc.