SELECT e.employee_id, e.role
FROM employee_dimension e
JOIN employee_performance_fact ep
ON e.employee_id = ep.employee_id
WHERE ep.month = 'January' AND ep.year = 2023
AND (ep.revenue_generated, ep.projects_completed) = (
SELECT MAX(revenue_generated), MAX(projects_completed)
FROM employee_performance_fact
WHERE month = 'January' AND year = 2023)
SELECT city, name, SUM(amount) AS TotalSpending
FROM customers_prc c
JOIN orders_prc o ON c.customerid = o.customer_id
GROUP BY city, name
HAVING TotalSpending = (SELECT MAX(TotalSpending)
FROM (SELECT city, name, SUM(amount) AS TotalSpending
FROM customers_prc c JOIN orders_prc o ON c.customerid = o.customer_id GROUP BY city, name) AS Subquery
WHERE Subquery.city = c.city);
