Mysql查询每个用户访问次数最多的url

CREATE TABLE access_log (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT,
    url VARCHAR(255),
    timestamp DATETIME
);

INSERT INTO access_log (user_id, url, timestamp)
VALUES
    (1, 'http://example.com/page1', '2022-01-01 10:00:00'),
    (1, 'http://example.com/page2', '2022-01-01 10:01:00'),
    (2, 'http://example.com/page1', '2022-01-01 10:02:00'),
    (2, 'http://example.com/page3', '2022-01-01 10:03:00'),
    (2, 'http://example.com/page3', '2022-01-01 10:04:00'),
    (3, 'http://example.com/page2', '2022-01-01 10:05:00');

SELECT user_id, url, COUNT(*) AS visit_count
FROM access_log
GROUP BY user_id, url
HAVING visit_count = (
    SELECT MAX(visit_count)
    FROM (
        SELECT user_id, url, COUNT(*) AS visit_count
        FROM access_log
        GROUP BY user_id, url
    ) AS counts
);