SELECT count()
FROM ct259_ods_user_star_project;

-- 宽表项目 3,061,520 + 外部镜像参考 27,810,220 = 30,871,740
SELECT count() FROM ct259_dwd_projects_full_info_wide;  -- 3,061,520
-- + 27,810,220（外部镜像参考，非宽表 gitclone 口径）

-- 近365天有 5 类贡献行为的去重仓库数；活跃维护率 = ③ ÷ ② = 48.6%
SELECT count(DISTINCT target_id)
FROM ct259_dwd_user_action_logs
WHERE act IN ('MergeRequest','codereview','commit','push','Issue')
  AND pt >= today() - 365;

-- clone/download 全量（git_download + web_download + release_download + lfs + ai_lfs）
SELECT sum(dl_num)
FROM ct259_dws_gitcode_repo_clone_download_event_pro;

SELECT count()
FROM ct259_dwd_projects_full_info_wide
WHERE repo_tag LIKE '%ugr%';

SELECT count(DISTINCT project_id)
FROM ct259_ods_topic_project_relation
WHERE topic_id IN ('6656c64efd46e722f6299761','6656c65ebacc215dac8b2d06');

SELECT count() FROM ct259_dwd_projects_full_info_wide WHERE repo_tag = 'gitclone';  -- 792,523
-- + 27,810,220（外部镜像参考）= 28,602,743

SELECT count(DISTINCT uid)
FROM ct259_dwd_user_action_logs
WHERE act IN ('MergeRequest','codereview','commit','push','Issue');

SELECT sumIf(act_cnt, act = 'commit')       AS commit_total,
       sumIf(act_cnt, act = 'MergeRequest') AS pr_total
FROM ct259_dwd_user_action_logs;

SELECT toStartOfQuarter(created_at) AS q,
       countIf(repo_tag LIKE '%ugr%')  AS ugr,
       countIf(repo_tag = 'gitclone')  AS mirror,
       countIf(repo_tag LIKE '%gstar%') AS gstar
FROM ct259_dwd_projects_full_info_wide
GROUP BY q ORDER BY q;
-- 页面折线为季度累计值（running sum）；镜像线含外部参考 27,810,220

SELECT p.path_with_namespace, sum(e.dl_num) AS dl
FROM ct259_dws_gitcode_repo_clone_download_event_pro e
GLOBAL JOIN ct259_dwd_projects_full_info_wide p ON toInt64(e.project_id) = p.id
GROUP BY p.path_with_namespace ORDER BY dl DESC LIMIT 10;

SELECT p.path_with_namespace, count() AS star
FROM ct259_ods_user_star_project s
GLOBAL JOIN ct259_dwd_projects_full_info_wide p ON toInt64(s.project_id) = p.id
GROUP BY p.path_with_namespace ORDER BY star DESC LIMIT 10;

SELECT a.repo_id, p.path_with_namespace, a.contributors
FROM (
  SELECT toInt64OrZero(target_id) AS repo_id, count(DISTINCT uid) AS contributors
  FROM ct259_dwd_user_action_logs
  WHERE act IN ('MergeRequest','codereview','commit','push','Issue')
  GROUP BY repo_id
) a
GLOBAL JOIN ct259_dwd_projects_full_info_wide p ON a.repo_id = p.id
WHERE p.path_with_namespace NOT LIKE '%will_delete%'
ORDER BY a.contributors DESC LIMIT 10;

SELECT count()
FROM ct259_dws_atomcode_new_devices_daily;

-- AtomCode 客户端 LLM 对话 Token 累计（input + output）
SELECT sum(input_tokens + output_tokens)
FROM ct259_dwd_atomcode_llm_chat
WHERE pt <= today() - 1;   -- = 7,299,662,730,184

SELECT sum(total_tokens)
FROM ct259_ods_assist_service_review_runs;   -- = 74,864,368,530

-- 当日活跃设备数（取近 5 个工作日均值）
SELECT count()
FROM ct259_dws_atomcode_active_devices_daily
WHERE pt = today() - 1;

SELECT sum(dl_num)
FROM ct259_dws_gitcode_repo_clone_download_event_pro
WHERE project_id = '9709354';

SELECT star_count, issue_cnt
FROM ct259_dwd_projects_full_info_wide
WHERE id = 9709354;   -- 4,153 / 4,299

SELECT count(DISTINCT uid)
FROM ct259_dwd_user_action_logs
WHERE target_id = '9709354'
  AND act IN ('MergeRequest','codereview','commit','push','Issue');   -- 589

SELECT toStartOfWeek(pt) AS w, sum(input_tokens + output_tokens) / 1e8 AS tok_yi
FROM ct259_dwd_atomcode_llm_chat
WHERE pt >= today() - 49
GROUP BY w ORDER BY w;

-- AI Coding = ②；AI Review = ③；两者之和为总 Token 7.37 万亿