Company: Quicksell_13nov
Difficulty: medium
Problem Description You are given a table named Leads containing information about various business leads. Your task is to write a SQL query that calculates the total number of leads for each industry. Schema Leads Table CREATE TABLE Leads ( Lead_Id INT, Created_Date VARCHAR(50), Industry VARCHAR(100) ); Lead_Id : Unique identifier for the lead. Created_Date : The month the lead was created. Industry : The industry the lead belongs to. Required Output The query must return exactly two columns in the following order: Industry : The name of the industry. Lead_Count : The total number of leads belonging to that industry. Constraints or Notes Group the results by the Industry column. Order the final result alphabetically by Industry in ascending order. Standard SQL is expected. You do not need to write DDL or DML statements to create or populate the tables. Examples Sample Input: Leads Table +---------+--------------+----------+ | Lead_Id | Created_Date | Industry | +---------+------------