/SQL/Sql query for getting data with join and count

Sql query for getting data with join and count

Correlated subquery

SELECT job_Desc
 ,(select count(*) from employee where employee.job_id = jobs.job_id) as count
FROM Jobs
ORDER BY 2

refrence:
https://azagappan.wordpress.com/2006/06/23/using-count-with-joins/#:~:text=COUNT(*)%20returns%20the%20number,number%20of%20unique%2C%20nonnull%20values.

Similar codes

10 votes340 views2 answers
SQL rounding numbers
SQL
-1 vote299 views2 answers
On delete set default sql server
SQL
6 votes331 views2 answers
Insert into select mysql
SQL
0 vote320 views1 answer
How to read the potentail error messages in ssis package
SQL
2 votes315 views1 answer
Pandas to sql index
SQL
1 vote299 views1 answer
How to see all table partition in oracle
SQL
0 vote328 views1 answer
Column ' ' in field list is ambiguous
SQL
-1 vote306 views2 answers
On update cascade
SQL
0 vote311 views1 answer
Alter table name including schema
SQL
0 vote322 views1 answer
How to select an index in oracle sql
SQL