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

Customer Emails with Active Accounts | Algorithm

EasyjoinsSQL

Customer Emails with Active Accounts

The customer engagement team needs a contact list for customers who presently hold active accounts, to inform them of important updates.

Return

email : the email address of each customer account_number : the number of each active account Only include accounts where the status is active . List the results sorted by email in alphabetical order.

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.