Write a select statement that will display customer number, customer name and the number of orders belong to the customer whose state is pennsylvania.. 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.