SOLVED: Given the below employee table as input, choose the query that displays departme ...

Given the below employee table as input, choose the query that displays department wise average salaries sorted in descending order.

ID ENAME DEPT SALARY
1 James Potter FSI 75000
2 Ethan McCarty ETA 90000
3 Emily Rayner ETA 25000
4 Jack Abraham ETA 30000

SELECT AVG(Salary) AvgSal, Dept FROM Employee GROUP BY Dept ORDER BY 1

SELECT AVG(Salary) AvgSal, Dept FROM Employee ORDER BY AVG(Salary) GROUP BY Dept

SELECT AVG(Salary) AvgSal, Dept FROM Employee GROUP BY Dept ORDER BY AvgSal DESC

SELECT Dept, AVG(Salary) AvgSal FROM Employee GROUP BY 1 ORDER BY 2 DESC

Verified Answer

Correct Option - c

To get all Infosys Certified Bigdata Testing Professional Exam questions Join Telegram Group https://grateful.prepflix.in/infy-lex-pdfs