DATA ANALYSIS in MySQL | INTERVIEW SCENARIOS

[@houseoftechconcepts]

To download the data file used in this video... Checkout the following link and Download the file from AVG over Window in MySQL section.......
houseoftechconcepts.com/pages/mySqlStudyMaterial.html

[@vishnuchalla11]

For the 1st question, to get average salary by department.....we can also use Group by also right ? Like this
SELECT department_name,Avg(salary)
FROM employee_data
GROUP BY department_name

[@houseoftechconcepts]

Yes.. There are many other alternatives to solve this question...