SQL Option

WITH location_counts AS (
    SELECT 
        location_id, 
        COUNT(*) AS company_count
    FROM company
    GROUP BY location_id
),
most_common_location AS (
    SELECT location_id
    FROM location_counts
    ORDER BY company_count DESC
    LIMIT 1
)
SELECT 
    p.name AS person_name,
    c.name AS company_name
FROM people p
JOIN company c ON p.company_id = c.company_id
JOIN most_common_location mcl ON c.location_id = mcl.location_id;