Problem Statement

Customers with Multiple Orders Problem Description You are given two tables, Customer and Orders , holding a shop's customer records and the orders those customers have placed. Table Customer contains the columns: Customer_Id , Customer_Name , City , and State . Table Orders contains the columns: Customer_Id , Product_Name , Quantity , and Price . The column formats are given below. Write a query that returns the name of each customer together with how many orders they placed, restricted to customers who placed more than a single order. Database Schema CREATE TABLE Customer ( Customer_Id VARCHAR(10), Customer_Name VARCHAR(20), City VARCHAR(20), State VARCHAR(30) ); CREATE TABLE Orders ( Customer_Id VARCHAR(10), Product_Name VARCHAR(20), Quantity INT(20), Price INT(30) ); Sample Data Customer Customer_Id | Customer_Name | City | State ------------|---------------|-----------|------------ 10 | Rupesh | Pune | Maharastra 20 | Sanket | Bangalore | Karnataka 30 | John | Lynden | Washington