Skip to content

Instantly share code, notes, and snippets.

@bogdan
Created November 27, 2014 16:47
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save bogdan/d50d2e9682abf18cb026 to your computer and use it in GitHub Desktop.
Save bogdan/d50d2e9682abf18cb026 to your computer and use it in GitHub Desktop.
development >> puts Campaign.group("length(name)").count.sb {first}.mp {join("-")}.to_yaml
(5.6ms) SELECT COUNT(*) AS count_all, length(name) AS length_name FROM `campaigns` GROUP BY length(name)
---
- 1-4
- 2-15
- 3-28
- 4-68
- 5-46
- 6-55
- 7-78
- 8-52
- 9-93
- 10-89
- 11-104
- 12-107
- 13-125
- 14-141
- 15-123
- 16-123
- 17-151
- 18-144
- 19-154
- 20-131
- 21-115
- 22-155
- 23-153
- 24-751
- 25-5160
- 26-141
- 27-160
- 28-167
- 29-161
- 30-149
- 31-122
- 32-152
- 33-349
- 34-171
- 35-132
- 36-164
- 37-119
- 38-100
- 39-74
- 40-74
- 41-82
- 42-85
- 43-61
- 44-80
- 45-70
- 46-53
- 47-54
- 48-54
- 49-53
- 50-58
- 51-48
- 52-36
- 53-40
- 54-30
- 55-28
- 56-32
- 57-34
- 58-27
- 59-40
- 60-29
- 61-28
- 62-25
- 63-20
- 64-28
- 65-21
- 66-25
- 67-26
- 68-23
- 69-19
- 70-27
- 71-19
- 72-20
- 73-23
- 74-19
- 75-26
- 76-18
- 77-17
- 78-15
- 79-18
- 80-32
- 88-1
- 114-1
- 117-1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment