产品经理需要学SQL吗？从零开始的SQL入门指南

-- 查询用户表中所有用户的姓名和注册时间
SELECT user_name, register_time
FROM users
WHERE register_time >= '2026-01-01'
ORDER BY register_time DESC
LIMIT 100;

-- 查询活跃用户（最近7天有登录）
SELECT user_id, user_name, last_login_time
FROM users
WHERE last_login_time >= DATE_SUB(CURDATE(), INTERVAL 7 DAY)
  AND status = 'active';

-- 查询用户的订单信息
SELECT u.user_name, o.order_id, o.order_amount, o.create_time
FROM users u
LEFT JOIN orders o ON u.user_id = o.user_id
WHERE o.create_time >= '2026-01-01';

-- 统计每个渠道的注册用户数和付费用户数
SELECT channel,
       COUNT(*) AS total_users,
       SUM(CASE WHEN is_paid = 1 THEN 1 ELSE 0 END) AS paid_users,
       ROUND(SUM(CASE WHEN is_paid = 1 THEN 1 ELSE

-- 找出月活跃用户数超过1000的城市
SELECT city, COUNT(DISTINCT user_id) AS mau
FROM user_login_log
WHERE login_time >= '2026-03-01' AND login_time < '2026-04-01'
GROUP BY city
HAVING COUNT(DISTINCT user_id) > 1000
ORDER BY mau DESC;

-- 计算2026年3月每天的次日留存率
SELECT a.login_date,
       COUNT(DISTINCT a.user_id) AS day_users,
       COUNT(DISTINCT b.user_id) AS retained_users,
       ROUND(COUNT(DISTINCT b.user_id) * 100.

-- 电商购买漏斗：浏览 -> 加购 -> 下单 -> 支付
SELECT
    COUNT(DISTINCT CASE WHEN event = 'view' THEN user_id END) AS view_users,
    COUNT(DISTINCT CASE WHEN event = 'add_cart' THEN user_id END) AS cart_users,
    COUNT(DISTINCT CASE WHEN event

-- 基于最近消费时间和消费金额对用户分层
SELECT user_id,
       DATEDIFF(CURDATE(), MAX(order_time)) AS recency_days,
       COUNT(*) AS frequency,
       SUM(order_amount) AS monetary,
       CASE
           WHEN DATEDIFF(CURDATE(), MAX(order_time)) <= 30 AND SUM(order_amount) >= 1000 THEN '高价值活跃'

-- 每个品类销售额Top3的商品
SELECT *
FROM (
    SELECT product_name, category, sales_amount,
           ROW_NUMBER() OVER (PARTITION BY category ORDER BY sales_amount DESC) AS rn
    FROM products
) t
WHERE rn <= 3;

-- 计算每月GMV的环比增长率
SELECT month,
       gmv,
       LAG(gmv) OVER (ORDER BY month) AS last_month_gmv,
       ROUND((gmv - LAG(gmv) OVER (ORDER BY month)) * 100.0 / LAG(gmv) OVER (ORDER BY month),