Customers with Multiple Orders

Problem Statement

Problem Description Write an SQL query to retrieve the names of the customers who have placed more than one order, along with the respective count of their orders. Each row in the Orders table represents a single order placed by a customer. Schema Customer Table: +---------------+--------------+ | Column Name | Data Type | +---------------+--------------+ | Customer_Id | VARCHAR(10) | | Customer_Name | VARCHAR(20) | | City | VARCHAR(20) | | State | VARCHAR(30) | +---------------+--------------+ Orders Table: +---------------+--------------+ | Column Name | Data Type | +---------------+--------------+ | Customer_Id | VARCHAR(10) | | Product_Name | VARCHAR(20) | | Quantity | INT | | Price | INT | +---------------+--------------+ Required Output The result should include the following columns: Customer_Name : The name of the customer. order_count : The total number of orders placed by that customer. Rules: Return only the customers who have an order_count greater than 1. Order the results