Struggling with simple query

Hi guys,

I have this table schema:

id | type | lang

01 | article | en
02 | article | ja
03 | blog | en
04 | blog | fr

And am trying to generate this report:

type | lang | count

article | en | 100
article | ja | 200
blog | en | 300
blog | fr | 200

I thought it would be simple but it’s proving to be beyond my skill set.
Any help you could offer would be appreciated.

Thanks,
Kevin

try

 
SELECT type,lang, COUNT(*)
FROM tblMyData
GROUP BY type,lang;

Wow, I feel stupid.

Thanks Kalon!

you’re welcome :slight_smile:

no need to feel stupid.

whether we admit it or not, we all had L plates on at some stage in our lives :slight_smile: