Problem Statement

Problem Description Write an SQL query that lists the names of customers who have placed more than one order, together with how many orders each of them placed. Each row of the Orders table represents one individual order. 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 by order_count in