This technical problem involves writing a SQL query to find all customers who have placed an order in the last 30 days. The example input data consists of a customers table with id and name columns, and an orders table with id, customer_id, and order_date columns. The example output lists the id and name columns for all customers who have placed an order in the last 30 days.
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.
Evaluated at: 2022-11-12 06:16:14