/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 vote125 views2 answers
Mysql current user
SQL
28 votes129 views4 answers
Show tables mysql
SQL
0 vote124 views1 answer
In mysql workbench contnent not feching
SQL
5 votes149 views1 answer
Oracle list functions
SQL
31 votes143 views4 answers
How to get duplicate records with multiple field in sql
SQL
0 vote165 views1 answer
Oracle sqlp update amount / quantity
SQL
1 vote161 views1 answer
Mysql current running queries
SQL
2 votes132 views1 answer
Find all triggers in database
SQL
1 vote129 views3 answers
Postgresql connect to database
SQL
0 vote131 views1 answer
Subquery aggregation
SQL