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

List Cardholders and Their Card Networks | Algorithm

EasyjoinsSQL

List Cardholders and Their Card Networks

The marketing team wants to understand which card networks are used by each customer for targeted promotions. For every customer who holds a card, provide their name along with the network of each card they possess.

Return

full_name (the customer’s full name) network (the network of the customer’s card) Include only customers who have cards, and order the results by full_name and then by network, both alphabetically.

Expected output

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