Company: Bank_Of_America
Difficulty: medium
Customers with Multiple Orders Problem Description You are given two tables Customer and Orders . 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 to get the names of the customers along with respective number of orders, who have more than one 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 40 | Sanjay | Bidar | Karnataka 50 | Jimmy | Jdgir | Maharastra 60 | Saif | Hyderabad | Telangana 70 | Raj | Thane | M