Write a query to find the number of employees in each job title.

Let's create table schema and sample data.

Table Schema and Sample data:-

CREATE TABLE employees 

( 

id INT PRIMARY KEY, 

name VARCHAR(50) NOT NULL, 

job_title VARCHAR(50) 

); 

INSERT INTO employees (id, name, job_title) VALUES 

(1, 'Asha', 'Software Engineer'), 

(2, 'Ravi', 'Software Engineer'), 

(3, 'Meera', 'Sales Executive'), 

(4, 'Kiran', 'Sales Executive'), 

(5, 'Neha', 'Sales Executive'), 

(6, 'Rohan', 'HR Manager'), 

(7, 'Tara', NULL);

Query:-

SELECT job_title, 

COUNT(*) AS employee_count 

FROM employees 

GROUP BY job_title 

ORDER BY employee_count DESC;