SQL · ByteDance · Medium
Write an SQL query that reports the number of daily new active users from the users table over the most recent 30 days. The table is defined as follows: Requirements: Return exactly two columns: date and new_active_users. Order the rows by date from earliest to latest. If the same user appears more than once for a given day, count that user only once for that date. Export the query result as a CSV file using the required column names and row format. Example Output date…
Checking your access…