Enterprise account info from PDW

gistfile1.sql

use dw_prod_analytics;

SELECT 
    a.account_id,
    a.subdomain,
    co.num_tickets,
    co.num_users,
    r.num_agents + r.num_admins activated_agents,
    a.max_agents
FROM
    accounts a
        INNER JOIN
    count_objects co USING (account_id , run_at , timespan)
        INNER JOIN
    roles r USING (account_id , run_at , timespan)
    INNER JOIN
    zuora_mrr mrr USING (account_id , run_at , timespan)
WHERE
    run_at = (SELECT 
            MAX(run_at)
        FROM
            accounts)
        AND a.plan_type = 4
        AND a.account_type = 'customer'
        AND mrr.mrr > 0