select version();

CREATE TABLE crm_leads ( id INTEGER NOT NULL PRIMARY KEY, lead_source INTEGER, lead_status INTEGER, sub_status INTEGER, enquiry_date datetime );

CREATE TABLE crm_sources ( id INTEGER NOT NULL PRIMARY KEY, title VARCHAR (50) );

INSERT INTO crm_leads VALUES (3, 2, 1, 6,'2021-10-02'), (4, 1, 3, 3,'2021-05-01'), (5, 4, 8, 6,'2020-10-01'), (6, 4, 1, 3,'2021-10-06'), (10, 2, 1, 3,'2021-10-06'), (11, 3, 5, 6,'2021-01-01');

INSERT INTO crm_sources VALUES (1, 'Business Card'), (2, 'Direct Call'), (3, 'Facebook'), (4, 'LinkedIn');

select * from crm_sources

SELECT `l`.`lead_status`, `crm_sources`.`title`, count(*) as leadnum, `l`.`enquiry_date` FROM `crm_leads` as `l` LEFT JOIN `crm_sources` ON `crm_sources`.`id`= `l`.`lead_source` WHERE `lead_status` <> 10 GROUP BY `l`.`lead_status`, `crm_sources`.`title` ORDER BY `leadnum` DESC, `crm_sources`.`title` ASC, `l`.`lead_status` ASC