在SQL中，如何根据特定列的Like消息来获取Count，Group by？

SELECT 
    SUBSTRING_INDEX(email, '@', -1) AS domain, 
    COUNT(*) AS user_count
FROM 
    users
WHERE 
    email LIKE '%@example.com'
GROUP BY 
    domain;

SELECT 
    SUBSTRING_INDEX(email, '@', -1) AS domain, 
    SUBSTRING_INDEX(SUBSTRING_INDEX(email, '.', -2), '.', 1) AS country_code, 
    COUNT(*) AS user_count
FROM 
    users
WHERE 
    email LIKE '%@%'
GROUP BY 
    domain, 
    country_code;

ALTER TABLE users ADD FULLTEXT idx_fulltext_email (email);

SELECT 
    SUBSTRING_INDEX(email, '@', -1) AS domain, 
    COUNT(*) AS user_count
FROM 
    users
WHERE 
    MATCH(email) AGAINST('+@example.com' IN BOOLEAN MODE)
GROUP BY 
    domain;