如何在单个SQL查询中组合多个计数

SELECT 
    (SELECT COUNT(*) FROM orders WHERE status = 'Pending') AS pending_count,
    (SELECT COUNT(*) FROM orders WHERE status = 'Completed') AS completed_count,
    (SELECT COUNT(*) FROM orders WHERE status = 'Cancelled') AS cancelled_count,
    (SELECT COUNT(*) FROM orders WHERE region = 'North') AS north_count,
    (SELECT COUNT(*) FROM orders WHERE region = 'South') AS south_count,
    (SELECT COUNT(*) FROM orders WHERE region = 'East') AS east_count,
    (SELECT COUNT(*) FROM orders WHERE region = 'West') AS west_count,
    COUNT(*) AS total_count
FROM orders;