Advertisement
festinko

Untitled

Sep 21st, 2022
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 25.38 KB | None | 0 0
  1. "< 10"
  2.     WHEN    countOfMonitors > 9 AND countOfMonitors < 21 THEN "10 - 20"
  3.     WHEN    countOfMonitors > 20 AND countOfMonitors < 31 THEN "21 - 30"
  4.     WHEN    countOfMonitors > 30 AND countOfMonitors < 41 THEN "31 - 40"
  5.     WHEN    countOfMonitors > 40 AND countOfMonitors < 51 THEN "41 - 50"
  6.     WHEN    countOfMonitors > 50 THEN "> 50"
  7.     END) monitorsCountInterval
  8.    
  9.     FROM
  10.         monitorsCount
  11.     ORDER BY
  12.         userID
  13.    
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement