For each customer with orders, return customer_id and favourite_method — their most used payment method (ties: alphabetically first).
14 rows with columns customer_id, favourite_method — first 3 shown:
| # | ||
|---|---|---|
| 1 | 3 | COD |
| 2 | 6 | UPI |
| 3 | 12 | Card |
Run your code to see the output here.