JavaScript is required for SkillDojo AI to work properly. Please enable JavaScript and refresh the page.

Customer Email and Account Number List | Algorithm

EasyjoinsSQL

Customer Email and Account Number List

The customer support team wants to quickly look up customer details when handling account inquiries. They need a list of every customer who has at least one account, showing each account they hold.

Return

full_name : the customer's full name email : the customer's email address account_number : the number for each account held by the customer Include only customers who have at least one account. Order the results by full_name and then by account_number, both in alphabetical order.

Expected output

First 3 of 8 rows your query should return. Your column aliases don't need to match.

SQLite · Ctrl+Enter to run

Run your query to see results here.