Write a select statement that will display customer number, customer name and the number of orders belong to the customer whose state is South Carolina. You will need to join two tables, use a COUNT aggregate and a GROUP BY clause in your SELECT statement. Override labels with a more descriptive but brief label.