Get count of posts for "non-standard" post formats in MySQL

post-format-counts.md

mysql> SELECT 
    ->     t1.slug, t2.count
    -> FROM
    ->     local.wp_terms AS t1
    ->         INNER JOIN
    ->     local.wp_term_taxonomy AS t2 ON t1.term_id = t2.term_id
    -> WHERE
    ->     t2.taxonomy = 'post_format';
+---------------------+-------+
| slug                | count |
+---------------------+-------+
| post-format-gallery |    51 |
| post-format-video   |   192 |
| post-format-link    |     0 |
+---------------------+-------+
3 rows in set (0.00 sec)