whole_surf_7437

Show each API call's endpoint and username (NULL when no user matches)

For each transaction, show the username, product_name, and a safe revenue calculation (quantity time

List each distinct product category alongside the total quantity sold for that category

For each user, show their username and the total number of distinct product categories they have pur

Combine user_ids from transactions and user_sessions using UNION ALL in a CTE

Combine all distinct user_ids from transactions and ad_impressions using UNION

For each session, show the previous session's page count using LAG

Rank transactions by total_amount descending using ROW_NUMBER

Return user_id, COUNT(DISTINCT product_id) AS unique_products, and COUNT(*) AS total_tx from transac

Return user_id and the sum of total_amount for transactions where quantity >= 2, aliased as qualifie