wordpress categories and total courses

wp_categories.sql

SELECT t.term_id,
       t.name,
       t.slug,
       count(post.ID) AS total
FROM wp_terms AS t
INNER JOIN wp_term_taxonomy AS tt ON (t.term_id = tt.term_id)
INNER JOIN wp_term_relationships AS tr ON (tr.term_taxonomy_id = tt.term_taxonomy_id)
LEFT JOIN wp_posts post ON (post.ID = tr.object_id)
WHERE tt.taxonomy IN ('course_category')
GROUP BY t.term_id
ORDER BY t.name ASC