I have an sql query:
SELECT Count(*) AS NationalParticipantsCount, Country
GROUP BY Country
HAVING Country = 'Germany'
Now the table Participant is empty in the beginning. So I get an empty response.
How do I modify my statement so it will display NationalParticipantsCount as "0" ?
Thanks a lot