SELECT AVG(score) FROM reviews WHERE product_id = 15;

SELECT email
FROM users
GROUP BY email
HAVING COUNT(*) > 1;

SELECT id, ts,
       LEAD(ts) OVER (ORDER BY ts) AS next_ts
FROM events;

SELECT user_id, COUNT(*) AS errors
FROM logs
WHERE level = 'ERROR'
  AND ts >= NOW() - INTERVAL '3 DAY'
GROUP BY user_id
HAVING COUNT(*) > (
  SELECT AVG(cnt)
  FROM (
    SELECT user_id, COUNT(*) AS cnt
    FROM logs
    WHERE level = 'ERROR'
    GROUP BY user_id
  ) t
);