Given two tables, find the person who has placed the maximum number of orders.
Asked in the Technical 1 stage. Return every person tied for the maximum, including people with no orders when applicable.
person_id, person_name, and order_count.person_id ascending.| Column | Type | Description |
|---|---|---|
| person_idPK | INT | Unique identifier for a person |
| person_name | VARCHAR(100) | Person's name |
| Column | Type | Description |
|---|---|---|
| order_idPK | INT | Unique identifier for an order |
| person_id | INT | Person who placed the order |
| order_status | VARCHAR(20) | Current order status |