SELECT CountryCode, COUNT(*) AS LinnadKokku --kirjete arv
FROM tCity
GROUP BY CountryCode
HAVING Count(*)>100
ORDER BY 1--COUNT(*) DESC

SELECT CountryCode, COUNT(District) AS LinnadKokku --DIstrictide arv
FROM tCity
GROUP BY CountryCode
HAVING Count(District) > 100
ORDER BY 1--COUNT(DIstrict) DESC

--SELECT * FROM tCity WHERE District IS NULL

(8 rows affected)

Warning: Null value is eliminated by an aggregate or other SET operation.

(8 rows affected)

(18 rows affected)

Total execution time: 00:00:00.036

CountryCode	LinnadKokku
BRA	250
CHN	363
IND	341
JPN	248
MEX	173
PHL	136
RUS	189
USA	274

CountryCode	LinnadKokku
BRA	250
CHN	363
IND	341
JPN	248
MEX	173
PHL	136
RUS	189
USA	274

ID	CityName	CountryCode	District	Population
61	South Hill	AIA	NULL	961
62	The Valley	AIA	NULL	595
129	Oranjestad	ABW	NULL	29034
536	Douglas	GBR	NULL	23487
915	Gibraltar	GIB	NULL	27025
920	Tamuning	GUM	NULL	9500
921	Agana	GUM	NULL	1139
1791	Flying Fish Cove	CXR	NULL	700
2694	Monte-Carlo	MCO	NULL	13154
2695	Monaco-Ville	MCO	NULL	1234
2727	Yangor	NRU	NULL	4050
2728	Yaren	NRU	NULL	559
2805	Alofi	NIU	NULL	682
2806	Kingston	NFK	NULL	800
2912	Adamstown	PCN	NULL	42
3208	Singapore	SGP	NULL	4017733
3493	Nouméa	NCL	NULL	76293
3538	Citta del Vaticano	VAT	NULL	455