Tables: Blogs (id, name) Users (id, name) Pages (id, title, data) Visits (id, user_id, blog_id, page_id) How many views every blog have? Result should be:: blog_id, blog_name, visits_count How many times each page has been accessed? Result should be: page_id, page_title, page_data, visits_count -- 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 unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/581d838990b22ab8ae3abf8c0c4c69f7%40ruby-forum.com. For more options, visit https://groups.google.com/d/optout.