试试这个：

SELECT nationality, COUNT(booking_id) AS TouristIdCount, MONTH(booking_date) AS MonthNumber
FROM users u
JOIN bookings b ON u.user_id = b.user_id
WHERE YEAR(booking_date) = 2022
GROUP BY nationality, MonthNumber
ORDER BY TouristIdCount DESC, MonthNumber ASC

您可以使用

having COUNT(b.tourist_id) >= 2

You want to count bookings per month and tourist's nationality and then show only the top nationality (or nationalities) per month.
There are two very similar approaches:

1. Rank the nationalities' booking counts per month with RANK and only show the best ranked rows.
2. Select the top booking count per month and only show rows matching their top count.
   The following query uses the second method. It shows one row per month and top booking nationality. Often there may be excatly one row for a month showing the one top booking nationality, but there may also be months where nationalities tie and share the same top booking count, in which case we see more than one row for a month.

select year, month, nationality, booking_count
from
(
  select
    year(b.booking_date) as year,
    month(b.booking_date) as month,
    u.nationality,
    count(*) as booking_count,
    max(count(*)) over (partition by year(b.booking_date), month(b.booking_date)) as months_max_booking_count
  from bookings b
  join users u on u.user_id = b.tourist_id
  group by year(b.booking_date), month(b.booking_date), u.nationality
) ranked
where booking_count = months_max_booking_count
order by year, month, nationality;

As your own sample data doesn't contain any edge cases, here is some other sample data along with my query's result and an explanation. (In other words, this is what you should have shown in your request ideally.)

users

bookings

result

In January there were two tours, but we are not interested in tours. We see four bookings, two by the Americans, two by the Britsh person. This is a tie, and we show two rows, one for UK and one for US with two bookings each.
In May there were five tours, but again, we are not interested in tours. There are seven bookings, four by the Americans, three by the Britsh person. So we only show US as the top country with four bookings here.