Hello,

I know this might be out of rails question, but I could not find any
other place to ask :D

select count(url_id) as url_count, user_id from urls_users group by
url_id limit 10;
+-----------+---------+
| url_count | user_id |
+-----------+---------+
|       238 |       1 |
|      3070 |       2 |
|       141 |       3 |
|         1 |       7 |
|       156 |       8 |
|       397 |      11 |
|         1 |      15 |
|        20 |      16 |
|        73 |      17 |
|       329 |      18 |
+-----------+---------+


How do I get the average url_count on all the users in that table based
on url_id?

Thanks for help.

-- 
Posted via http://www.ruby-forum.com/.

-- 
You received this message because you are subscribed to the Google Groups "Ruby 
on Rails: Talk" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/rubyonrails-talk?hl=en.

Reply via email to