desc programming_lang;
desc cnt;
SELECT * from programming_lang;
SELECT * from cnt;
SELECT
a.id as lang_id,
a.name as name,
b.cnt as cnt
FROM programming_lang a
LEFT JOIN cnt b on a.id=b.lang_id;
SELECT
a.id as lang_id,
a.name as name,
b.cnt as cnt
FROM programming_lang a
right JOIN cnt b on a.id=b.lang_id;