Glovo Interview Question

They asked me to write a SQL query using JOIN and aggregate functions (e.g., COUNT, SUM) to analyze a dataset.