forked from ptweir/python-string-sql
-
Notifications
You must be signed in to change notification settings - Fork 4
Open
Description
For this:
gateway-grouped-maturity: >
WITH v AS (
SELECT ${label} label,
count(distinct a.gateway) total,
count(distinct m.gateway) mature,
count(distinct e.gateway) empty,
count(distinct l1.gateway) l1mature,
count(distinct l2.gateway) l2mature,
count(distinct l3.gateway) l3mature
FROM ${database.gateways.view} a
LEFT JOIN ${database.mature-gateways.view} m USING (licenseGroup, gateway)
LEFT JOIN ${database.empty-gateways.view} e USING (licenseGroup, gateway)
LEFT JOIN ${database.l1mature-gateways.view} l1 USING (licenseGroup, gateway)
LEFT JOIN ${database.l2mature-gateways.view} l2 USING (licenseGroup, gateway)
LEFT JOIN ${database.l3mature-gateways.view} l3 USING (licenseGroup, gateway)
GROUP BY ${groups}
)
SELECT label,
total,
mature,I see (note red closing parenthesis):
Metadata
Metadata
Assignees
Labels
No labels
