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
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
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
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
Yes.. There are many other alternatives to solve this question...