Monthly Percentage of High-Frequency Customers

We have an orders table that records every order placed. order_id is the primary key. Each row corresponds to a single order made by a customer. For each calendar month, we want to know what fraction of active customers are “high-frequency” customers. A customer is active in a given month if they placed at least one order during that month. A high-frequency customer is one who placed strictly more than 30 orders in that same month. Return a result set with these columns:…