This lesson's interactive features are locked, please to keep using them

Query Practice – Invoice Subquery

Certain customers have been using their personal CashPal accounts for business expenses. CashPal is trying to contact these customers so they can upsell business accounts.

Assignment

Using the transactions and users tables, write an SQL statement with a subquery that retrieves full user records for every user who:

Matches the sender_id in a transaction with "invoice" or "tax" mentioned anywhere in the transaction note.
And is not an admin.