gentle_dawn_6511

Calculate the per-unit price by dividing total_amount by quantity

Select product_name and use CAST to convert price to DECIMAL(10,2)

Select product_name, price, and in_stock from products, but only where in_stock IS NOT NULL.

Find users whose email address is NULL

Union the usernames from users with account_status 'active' and the user_ids cast to varchar from tr

Return user_id and username from users where user_id is in the set of user_ids that appear in transa

Using a CTE named big_spenders that selects user_id and SUM(total_amount) AS total from transactions

Use a CTE to calculate average session duration per user, then show usernames sorted by longest aver

Find product categories where the average price exceeds 100

Use a CTE to count each user's transactions, then show usernames with 3 or more transactions