Im trying to select a list of categories, and display them, as well as list number of videos in each category. I have 2 tables, categories (cat_id, cat_name), and videos (vid_id, vid_catid, etc). cat_id = vid_catid. I need 1 query that will select the category names + number of rows in the video table that has each category in its vid_catid column. How would I accomplish that?