/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

1 vote276 views2 answers
How to combine 2 tables in MySQL
SQL
0 vote268 views1 answer
How to create a new db from dumb file mysql
SQL
0 vote272 views1 answer
Execut sql python
SQL
10 votes218 views2 answers
Django mysql
SQL
0 vote246 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
22 votes285 views4 answers
Date format mysql
SQL
1 vote270 views1 answer
Oracle drop chain step
SQL
8 votes265 views2 answers
Alert table name mysql
SQL
0 vote264 views1 answer
Vbscript clean up ADODB.Recordset
SQL
0 vote249 views1 answer
T-sql conditional order by multiple columns
SQL