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

Active Accounts per Customer | Algorithm

EasyjoinsSQL

Active Accounts per Customer

The customer relations manager needs a list of all customers who currently have active accounts, to coordinate engagement efforts.

Return

full_name (the customer’s full name) account_number (the number of each active account) Include only accounts where status is'active' . Order the results alphabetically by full_name .

Expected output

First 3 of 7 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.