Initializing SQL database...
Back to Questions
Join customers with orders #56
mediumShow customer_name with their order_amount. This involves joining multiple tables or using different join types (LEFT JOIN, RIGHT JOIN). Pay attention to which join type is needed based on whether you want to include unmatched rows.
Practice with:
Database Schema
customers
customers information
idnameref_id
orders
orders information
idname
Expected Output
Click "Show" to see what the correct output should look like.Tip: Try solving it yourself first for better learning!
SQL Editor
Loading...
Press Ctrl+Enter to run query • Start typing for autocomplete