如何使用Active Record（计数，组，顺序）进行SQL查询

I'm learning AR and attempting to build an Excel like table via a query to my database. I would appreciate any help in finding an efficient query for my conundrum.I'm learning AR and attempting to build an Exce