J’espère que la requête suivante vous aidera.\n\n\nsql\n--[params]\n--date :start_date\n--date :end_date\n\nWITH posts_data AS (\n SELECT \n COUNT(*) AS total_posts,\n SUM(CASE\n WHEN u.admin = 't' OR u.moderator = 't' THEN 1 \n ELSE 0\n END) AS staff_posts\n FROM posts p\n INNER JOIN users u ON u.id = p.user_id\n WHERE p. post_type = 1\n AND p.deleted_at ISNULL\n AND p.created_at BETWEEN :start_date AND :end_date\n AND p.user_id \u003e 0\n)\n \nSELECT \n total_posts, \n staff_posts,\n ROUND((staff_posts/total_posts::decimal)*100,2) \"staff_posts %\"\nFROM posts_data\n\n\n|total_posts|staff_posts|staff_posts %|\n|—|—|—|\n|7400|3108|42.0|