4-round competitions 2019

mysql> select competitionId, eventId, count(distinct roundTypeId) as rounds, count(distinct personId) as people from Results join Competitions on Results.competitionId=Competitions.id where Competitions.year=2019 group by 1,2 having rounds=4 order by eventId asc, people desc;
+-------------------------------+---------+--------+--------+
| competitionId                 | eventId | rounds | people |
+-------------------------------+---------+--------+--------+
| CubingUSANationals2019        | 222     |      4 |    661 |
| ChinaChampionship2019         | 222     |      4 |    601 |
| Shenzhen10thAnniversary2019   | 222     |      4 |    237 |
| CanadianChampionship2019      | 222     |      4 |    168 |
| ZhongshanChildrensDay2019     | 222     |      4 |    165 |
| SwedishChampionship2019       | 222     |      4 |    151 |
| Xian10thAnniversary2019       | 222     |      4 |    121 |
| NordicChampionship2019        | 222     |      4 |    106 |
| ChinaChampionship2019         | 333     |      4 |    843 |
| WC2019                        | 333     |      4 |    807 |
| CubingUSANationals2019        | 333     |      4 |    738 |
| Shenzhen10thAnniversary2019   | 333     |      4 |    425 |
| ZhongshanChildrensDay2019     | 333     |      4 |    367 |
| UKChampionship2019            | 333     |      4 |    280 |
| IndianNationals2019           | 333     |      4 |    262 |
| SmartcubeFestKyiv2019         | 333     |      4 |    252 |
| GermanNationals2019           | 333     |      4 |    232 |
| MunichOpen2019                | 333     |      4 |    211 |
| Xian10thAnniversary2019       | 333     |      4 |    210 |
| PeruNationals2019             | 333     |      4 |    191 |
| CanadianChampionship2019      | 333     |      4 |    182 |
| SwedishChampionship2019       | 333     |      4 |    178 |
| ItalianChampionship2019       | 333     |      4 |    178 |
| FrenchChampionship2019        | 333     |      4 |    178 |
| LondonOpen2019                | 333     |      4 |    176 |
| GreatLakesChampionship2019    | 333     |      4 |    175 |
| SlowNSteadySummer2019         | 333     |      4 |    161 |
| BudapestOpen2019              | 333     |      4 |    156 |
| KoreanChampionship2019        | 333     |      4 |    145 |
| ReturntoToronto2019           | 333     |      4 |    141 |
| LvivSpringDays2019            | 333     |      4 |    140 |
| AjaxWinter2019                | 333     |      4 |    137 |
| Indiana2019                   | 333     |      4 |    130 |
| HungarianOpen2019             | 333     |      4 |    129 |
| HighWycombeOpen2019           | 333     |      4 |    129 |
| Shenzhen3x3Days2019           | 333     |      4 |    128 |
| NacionalesMedellinExplora2019 | 333     |      4 |    126 |
| NordicChampionship2019        | 333     |      4 |    124 |
| MelbourneSummer2019           | 333     |      4 |    123 |
| NationalCapitalRegion2019     | 333     |      4 |    117 |
| OculusCubeOpen2019            | 333     |      4 |    116 |
| HamburgInternational2019      | 333     |      4 |    111 |
| KoalaficationBrisbane2019     | 333     |      4 |    110 |
| SpanishChampionship2019       | 333     |      4 |    108 |
| Ayase2019                     | 333     |      4 |    107 |
| BUWinter2019                  | 333     |      4 |    107 |
| KjellerOpen2019               | 333     |      4 |    106 |
| PolishChampionship2019        | 333     |      4 |    104 |
| ElsassOpen2019                | 333     |      4 |    102 |
| Cubetcha2019                  | 333     |      4 |    101 |
| MichiganCubingClubBeta2019    | 333     |      4 |    101 |
| NorwegianChampionship2019     | 333     |      4 |    100 |
| ChinaChampionship2019         | 333oh   |      4 |    242 |
| CanadianChampionship2019      | 333oh   |      4 |    122 |
| CubingUSANationals2019        | 444     |      4 |    367 |
| ChinaChampionship2019         | 444     |      4 |    263 |
| ChinaChampionship2019         | pyram   |      4 |    425 |
| CubingUSANationals2019        | pyram   |      4 |    424 |
| Shenzhen10thAnniversary2019   | pyram   |      4 |    144 |
| SwedishChampionship2019       | pyram   |      4 |    125 |
| ChinaChampionship2019         | skewb   |      4 |    227 |
| SwedishChampionship2019       | skewb   |      4 |    105 |
+-------------------------------+---------+--------+--------+