{
  "db_name": "PostgreSQL",
  "query": "WITH active_users as (SELECT distinct username as email FROM audit WHERE timestamp > NOW() - INTERVAL '1 month' AND (operation = 'users.login' OR operation = 'oauth.login')),\n        active_authors as (SELECT distinct email FROM usr WHERE usr.operator IS false AND email IN (SELECT email FROM active_users)),\n        active_authors_agg as (SELECT array_agg(email) as authors FROM active_authors),\n        active_ops_agg as (SELECT array_agg(email) as operators from active_users WHERE email NOT IN (SELECT email FROM active_authors))\n        SELECT active_authors_agg.authors, active_ops_agg.operators, array_length(active_authors_agg.authors, 1) as author_count, array_length(active_ops_agg.operators, 1) as operator_count FROM active_authors_agg, active_ops_agg",
  "describe": {
    "columns": [
      {
        "ordinal": 0,
        "name": "authors",
        "type_info": "VarcharArray"
      },
      {
        "ordinal": 1,
        "name": "operators",
        "type_info": "VarcharArray"
      },
      {
        "ordinal": 2,
        "name": "author_count",
        "type_info": "Int4"
      },
      {
        "ordinal": 3,
        "name": "operator_count",
        "type_info": "Int4"
      }
    ],
    "parameters": {
      "Left": []
    },
    "nullable": [
      null,
      null,
      null,
      null
    ]
  },
  "hash": "cce991f582bc9d2ba28a5b2b41c679366bb07bc6a100727721a787160ac6910c"
}
