Crowdly

Add to Chrome

An SQL statement to find the average salary and number of employees in each depa...

✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.

An SQL statement to find the average salary and number of employees in each department can be

None of these

0%

select avg(salary), count(*) from employee join department group by dname

50%

select avg(salary), count(*) from employee join department on dno = dnumber group by dname

50%

select avg(salary), count(*) from employee join department on dno = dnumber

0%

More questions like this

Want instant access to all verified answers on moovit.vit.ac.in?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Add to Chrome

Telegram Instagram TikTok Question Bank

Terms of Use Contact Us