To count and select group records in terminal use this command.
SELECT *, (SELECT COUNT([column]) FROM [table]) AS count FROM [table] GROUP BY [column];
Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408
Please like, share and subscribe.
I hope you enjoyed the article. If I was able to help you please consider a tip for the content.
One Time Tip