monthly_targets and the view v_monthly_sales cover different months. For every month in
either one, show month, target_amount, revenue and result, using the first rule that applies:
no target when the month has no targetno sales when the month has no salesmet when revenue is at least the targetmissed otherwiseEnd your query with ORDER BY month.
| monthly_targets |
|---|
| month (PK) |
| target_amount |
| v_monthly_sales |
|---|
| month |
| revenue |
monthly_targets and the view v_monthly_sales cover different months. For every month in
either one, show month, target_amount, revenue and result, using the first rule that applies:
no target when the month has no targetno sales when the month has no salesmet when revenue is at least the targetmissed otherwiseEnd your query with ORDER BY month.
| monthly_targets |
|---|
| month (PK) |
| target_amount |
| v_monthly_sales |
|---|
| month |
| revenue |
| month | target_amount | revenue | result |
|---|---|---|---|
| 2024-01-01T00:00:00.000Z | NULL | 86045.75 | no target |
| 2024-02-01T00:00:00.000Z | NULL | 160795.80 | no target |
| 2024-03-01T00:00:00.000Z | NULL | 106514.20 | no target |
| 2024-04-01T00:00:00.000Z | NULL | 70376.40 | no target |
| 2024-05-01T00:00:00.000Z | NULL | 100816.90 | no target |
| 2024-06-01T00:00:00.000Z | NULL | 106814.30 | no target |
| 2024-07-01T00:00:00.000Z | 115000.00 | 131206.30 | met |
| 2024-08-01T00:00:00.000Z | 100000.00 | 111037.45 | met |
| 2024-09-01T00:00:00.000Z | 105000.00 | 102490.15 | missed |
| 2024-10-01T00:00:00.000Z | 110000.00 | 143928.25 | met |
| 2024-11-01T00:00:00.000Z | 115000.00 | 79548.25 | missed |
| 2024-12-01T00:00:00.000Z | 100000.00 | 50557.95 | missed |
| 2025-01-01T00:00:00.000Z | 105000.00 | 160247.90 | met |
| 2025-02-01T00:00:00.000Z | 110000.00 | 146676.55 | met |
| 2025-03-01T00:00:00.000Z | 115000.00 | 100916.70 | missed |
| 2025-04-01T00:00:00.000Z | 100000.00 | 72001.05 | missed |
| 2025-05-01T00:00:00.000Z | 105000.00 | 145151.80 | met |
| 2025-06-01T00:00:00.000Z | 110000.00 | 136436.15 | met |
| 2025-07-01T00:00:00.000Z | 115000.00 | 134804.70 | met |
| 2025-08-01T00:00:00.000Z | 100000.00 | 26616.35 | missed |
| 2025-09-01T00:00:00.000Z | 105000.00 | 251053.35 | met |
| 2025-10-01T00:00:00.000Z | 110000.00 | 63006.65 | missed |
| 2025-11-01T00:00:00.000Z | 115000.00 | 8999.00 | missed |
| 2025-12-01T00:00:00.000Z | 100000.00 | 5297.00 | missed |
| 2026-01-01T00:00:00.000Z | 105000.00 | 2999.00 | missed |
| 2026-02-01T00:00:00.000Z | 110000.00 | NULL | no sales |
| 2026-03-01T00:00:00.000Z | 115000.00 | 3998.00 | missed |
| 2026-04-01T00:00:00.000Z | 100000.00 | 1099.00 | missed |
| 2026-05-01T00:00:00.000Z | 105000.00 | 3299.00 | missed |
| 2026-06-01T00:00:00.000Z | 110000.00 | 15499.00 | missed |
| 2026-07-01T00:00:00.000Z | 115000.00 | 2199.00 | missed |
| 2026-08-01T00:00:00.000Z | 100000.00 | NULL | no sales |
| 2026-09-01T00:00:00.000Z | 105000.00 | NULL | no sales |
| 2026-10-01T00:00:00.000Z | 110000.00 | NULL | no sales |
| 2026-11-01T00:00:00.000Z | 115000.00 | NULL | no sales |
| 2026-12-01T00:00:00.000Z | 100000.00 | NULL | no sales |
Run query to see output