rural_jay_3142

From users, return COUNT(*) AS total_users and COUNT(age_bucket) AS with_age on one row; then subtra

From users, return user_id and NULLIF(account_status, 'suspended') AS status_or_null

From users, return user_id and COALESCE(age_bucket, 'unknown') AS age_group

Show each product's product_id and a display name

Calculate the true average response time from server_logs, excluding entries where response_time_ms

Calculate the unit price for each transaction by dividing total_amount by quantity

Show each product's product_name, category, and the result of replacing NULL ratings with 0 using CO

Count the total server log entries and compare how many have a response time recorded versus missing

Find products that are missing a rating or have a NULL category

Show each product's product_name, rating, and the result of converting any 0 rating to NULL using NU