Contents

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

Version data entries

17 entries across 17 versions & 1 rubygems

Version	Path
agile-proxy-0.1.24	assets/ui/bower_components/ace-builds/demo/kitchen-sink/docs/sql.sql
agile-proxy-0.1.23	assets/ui/bower_components/ace-builds/demo/kitchen-sink/docs/sql.sql
agile-proxy-0.1.22	assets/ui/bower_components/ace-builds/demo/kitchen-sink/docs/sql.sql
agile-proxy-0.1.21	assets/ui/bower_components/ace-builds/demo/kitchen-sink/docs/sql.sql
agile-proxy-0.1.20	assets/ui/bower_components/ace-builds/demo/kitchen-sink/docs/sql.sql
agile-proxy-0.1.19	assets/ui/bower_components/ace-builds/demo/kitchen-sink/docs/sql.sql
agile-proxy-0.1.18	assets/ui/bower_components/ace-builds/demo/kitchen-sink/docs/sql.sql
agile-proxy-0.1.13	assets/ui/bower_components/ace-builds/demo/kitchen-sink/docs/sql.sql
agile-proxy-0.1.12	assets/ui/bower_components/ace-builds/demo/kitchen-sink/docs/sql.sql
agile-proxy-0.1.11	assets/ui/bower_components/ace-builds/demo/kitchen-sink/docs/sql.sql
agile-proxy-0.1.10	assets/ui/bower_components/ace-builds/demo/kitchen-sink/docs/sql.sql
agile-proxy-0.1.9	assets/ui/bower_components/ace-builds/demo/kitchen-sink/docs/sql.sql
agile-proxy-0.1.8	assets/ui/bower_components/ace-builds/demo/kitchen-sink/docs/sql.sql
agile-proxy-0.1.7	assets/ui/bower_components/ace-builds/demo/kitchen-sink/docs/sql.sql
agile-proxy-0.1.6	assets/ui/bower_components/ace-builds/demo/kitchen-sink/docs/sql.sql
agile-proxy-0.1.5	assets/ui/bower_components/ace-builds/demo/kitchen-sink/docs/sql.sql
agile-proxy-0.1.4	assets/ui/bower_components/ace-builds/demo/kitchen-sink/docs/sql.sql