m0v3x

Return username and SUM(total_amount) AS total_spent for users whose account_status is 'active' usin

Find usernames that have NO transactions

Return username and the count of transactions per user using LEFT JOIN so users with no transactions

List every product alongside the buyer's username and the transaction amount

Show every user along with the device type and OS name from their sessions

Join users, transactions, and products to show what each user purchased

Use a FULL OUTER JOIN between users and content_items, matching user_id to creator_id

Use a RIGHT JOIN to show all transactions alongside the username of the buyer

Show all users and their sessions longer than 300 seconds

Show each user with their clicked ad campaigns using LEFT JOIN, ordered by username and campaign