Solutions:
Check these solutions from our community and artificial intelligence:
The solution above is optimal because it uses a JOIN to combine the orders and customers tables. This allows us to access the name column from the customers table.