{
  "db_name": "PostgreSQL",
  "query": "\n        SELECT TO_CHAR(DATE_TRUNC('week', created_at), '\"Week\" W') AS week_name,\n               COALESCE(SUM(amount_inr), 0) AS total\n        FROM payments\n        WHERE status = 'SUCCESS' AND created_at >= NOW() - INTERVAL '28 days'\n        GROUP BY DATE_TRUNC('week', created_at), week_name\n        ORDER BY DATE_TRUNC('week', created_at)\n        ",
  "describe": {
    "columns": [
      {
        "ordinal": 0,
        "name": "week_name",
        "type_info": "Text"
      },
      {
        "ordinal": 1,
        "name": "total",
        "type_info": "Int8"
      }
    ],
    "parameters": {
      "Left": []
    },
    "nullable": [
      null,
      null
    ]
  },
  "hash": "62bb79b63f0f8aa69750883dfce2d6513c7611ba2083606ca0f0319d1ef7a8da"
}
