/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

4 votes254 views1 answer
List tables sqlite
SQL
1 vote270 views2 answers
One to one and one to many relationship
SQL
0 vote273 views1 answer
How to add mysql to path on termin after installation
SQL
2 votes288 views1 answer
Coalesce sql
SQL
0 vote267 views2 answers
Sql server Insert Into table
SQL
0 vote247 views1 answer
Mysqlimport
SQL
0 vote291 views1 answer
Sql script to remove default from column
SQL
0 vote262 views1 answer
Ubuntu connect to mssql database
SQL
0 vote255 views1 answer
How many rows affected in sqllite
SQL
0 vote270 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL