DAU (Daily Active Users)

Problem

The executive team wants to see a count of unique active customers per day. Find the count of unique customer_id grouped by order_date. Output order_date and dau.

Database Schema

Table: customers

• customer_id (INT): Unique identifier for the customer.
• first_name (VARCHAR): First name.
• last_name (VARCHAR): Last name.

Table: products

• product_id (INT): Unique identifier for the product.
• name (VARCHAR): Product name.
• price (DECIMAL): Product price.
• category (VARCHAR): Product category.

Table: orders

• order_id (INT): Unique identifier for the order.
• customer_id (INT): Foreign key referencing the customer.
• order_date (DATE): Date of the order.
• amount (DECIMAL): Total order amount.

Try It

Hint

Solution