Guest User

WN Caster Appearances 2023-08

a guest
Sep 11th, 2023
151
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PostgreSQL 0.21 KB | Software | 0 0
  1. SELECT caster,
  2.        COUNT(caster) AS appearances
  3.   FROM schedule_joined
  4.  WHERE caster IS NOT NULL
  5.    AND jst BETWEEN '2023-08-01' AND '2023-09-01'
  6.  GROUP BY caster
  7.  ORDER BY appearances DESC, caster ASC;
  8.  
Advertisement
Add Comment
Please, Sign In to add comment