ORDERS Order# Customer# Orderdate Shipdate Shipstreet Shipcity Shipstate Shipzip Shipcost CUSTOMERS Customer# Lastname Firstname Email Address City State Zip Referred Region BOOKAUTHOR AUTHOR ВОOKS...

please use sql to answer the following question and erd had been attach

4.Determine how many orders have been placed by each customer. Do not include in the results any customer who hasn’t recently placed an order with JustLee Books.(Group By / Subquery)

Extracted text: ORDERS Order# Customer# Orderdate Shipdate Shipstreet Shipcity Shipstate Shipzip Shipcost CUSTOMERS Customer# Lastname Firstname Email Address City State Zip Referred Region BOOKAUTHOR AUTHOR ВОOKS AuthorD ISBN ISBN AuthorID Lname Fname ORDERITEMS Title Pubdate PubID Cost Retall Discount Category Order# Item# ISBN Quantity Paideach PUBLISHER PubID Name PROMOTION Contact Gift Minretail Maxretall Phone FIGURE 1-5 JustLee Books's table structures after normalization