Advertisement
mardrdr

Untitled

Jun 29th, 2020
133
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.65 KB | None | 0 0
  1. select
  2.     COUNT(user_id) AS total
  3. FROM (
  4.     SELECT
  5.         user_id,
  6.         center_id,
  7.         start,
  8.         trial_id,
  9.         sign
  10.     FROM user_results__2020 r
  11.     WHERE status = 1
  12.         AND IFNULL(result, "") <> ""
  13.         AND MONTH(start) BETWEEN 1 AND 3
  14.         AND start = (
  15.             SELECT
  16.                 MAX(start)
  17.             FROM user_results__2020
  18.             WHERE user_id = r.user_id
  19.                 AND trial_id = r.trial_id
  20.                 AND center_id = r.center_id
  21.                 AND status = 1
  22.                 AND MONTH(start) BETWEEN 1 AND 3
  23.                 AND IFNULL(result, "") <> ""
  24.             )
  25.     ) ur;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement