Nombre d'utilisateurs ayant vu du contenu texte généré par l'IA dans les questions
Cette requête permet de compter le nombre d'utilisateurs ayant vu du contenu généré par l'IA.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25 | WITH
question_ai_generated AS (
SELECT
id
FROM
translation
WHERE
ai_generated IS NOT NULL
)
SELECT
COUNT(DISTINCT user_activity.user_id) AS user_seeing_ai_generated_content_count
FROM
user_activity
JOIN activity_item ON activity_item.activity_id = user_activity.activity_id
JOIN activity_item_content_part_pivot ON activity_item_content_part_pivot.activity_item_id = activity_item.id
JOIN exam_part ON exam_part.id = activity_item_content_part_pivot.exam_part_id
JOIN exam_question ON exam_question.exam_part_id = exam_part.id
WHERE
user_activity.started_at >= '2025-08-14 15:00:00' -- Date de la première régulation de contenu IA
AND exam_question.id IN (
SELECT
id
FROM
question_ai_generated
);
|
Keywords
user count ai_generated ai nombre utilisateur