bet smuki īstenībā:

SELECT COUNT(*), nationality.name
FROM nationality RIGHT JOIN rez ON (nationality.id = Rez.nationality)
GROUP BY nationality.name;

returned:
COUNT() nationality.name
2 Austrian
5 Belgian
4 Czech
3 Danish
4 Dutch
5 Estonian
10 Finnish
3 French
4 German
2 Greek
11 Hungarian
2 Irish
6 Italian
32 Latvian
4 Lithuanian
1 Luxembourger
2 Maltese
3 Other
10 Polish
1 Portuguese
12 Slovak
21 Slovenian
3 Spanish
9 Swedish
14 UK


---
jāsaka tīri ok pārklājums