Calculate Daily Active Users (DAU) with SQL

This tests your ability to translate a business metric into a precise technical definition and SQL query. A great answer first clarifies the definition of an "active" user (e.g., 'Edit Canvas'), then outlines the necessary event data (user_id, timestamp, event_name). The SQL query should use DATE_TRUNC to group by day and COUNT(DISTINCT user_id) to ensure uniqueness. A common red flag is writing a query without first discussing what "active" means for the specific business, as this definition is highly variable.