GROUP BY and COUNT(*)

My SQL is working on my web server:

Web database SQL1434×541 50.7 KB

I can’t get it to work in Wappler:

Database Custom Query701×396 21.3 KB

What to do?
Thanks,
Trolle