{
  "db_name": "SQLite",
  "query": "SELECT u.id AS \"id!: String\",\n                      u.email AS \"email!: String\",\n                      COUNT(DISTINCT r.movie_id) AS \"total_movies!: i64\",\n                      AVG(CAST(r.rating AS REAL)) AS avg_rating,\n                      u.avatar_path\n               FROM users u\n               LEFT JOIN reviews r ON r.user_id = u.id AND r.remote_actor_url IS NULL\n               GROUP BY u.id, u.email, u.avatar_path\n               ORDER BY u.email ASC",
  "describe": {
    "columns": [
      {
        "name": "id!: String",
        "ordinal": 0,
        "type_info": "Text"
      },
      {
        "name": "email!: String",
        "ordinal": 1,
        "type_info": "Text"
      },
      {
        "name": "total_movies!: i64",
        "ordinal": 2,
        "type_info": "Integer"
      },
      {
        "name": "avg_rating",
        "ordinal": 3,
        "type_info": "Float"
      },
      {
        "name": "avatar_path",
        "ordinal": 4,
        "type_info": "Text"
      }
    ],
    "parameters": {
      "Right": 0
    },
    "nullable": [
      true,
      false,
      false,
      true,
      true
    ]
  },
  "hash": "771236034946abb52809203ba9a1259900e343174cf3f435fc18d9e689deb187"
}
