sql.sql 132 B

123456
  1. SELECT city, COUNT(id) AS users_count
  2. FROM users
  3. WHERE group_name = 'salesman'
  4. AND created > '2011-05-21'
  5. GROUP BY 1
  6. ORDER BY 2 DESC