hardy_brook_5019

Find the average session duration in minutes for each user

Show each user's username, transaction ID, and days between signup and transaction using DATE_DIFF

Find which day of the week has the most deployments

Summarize total transaction revenue by fiscal quarter

Count how many users signed up each month

Find what hour each user session started

Extract the signup year from each user

From api_calls, return call_id and REPLACE(endpoint, '/api/', '/') AS short_path

From api_calls, return call_id and SUBSTR(endpoint, 1, 8) AS prefix for rows where endpoint LIKE '/a

From api_calls, return call_id, endpoint, and STRPOS(SUBSTR(endpoint, 2), '/') AS next_slash for row