You can use the following sql query state

To retrieve the number of customers who had orders after March 17, 2015, in each state, you can use the following SQL query:

SELECT State, COUNT(*) AS total_customer