Solutions:
Check these solutions from our community and artificial intelligence:
This solution is complete and solves the problem. The approach is to join the customers and orders table on the customer id and then filter for orders that have been placed in the last 30 days. This approach is sensible and efficient.