Your question is Summarize Customer Activity for Reports. Start with the requirements and the three tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Write a PostgreSQL query that combines accounts, properties, and sync_runs to generate a January 2024 customer report. Return one row per account with property count, successful January sync count, total January records processed from successful syncs, and a derived health label.