Write a SQL Query to find Max salary of each Department with department name. #sqlinterviewquestion

Write a SQL Query to find Max salary of each Department with department name. This is a trick question. There can be some departments without any employees. So we have to ask the interviewer if they expect the name of such Department also in the result. If you want to be better in Analytics, then do follow the below Playlist:- Excel Playlist:-https://www.youtube.com/watch?v=E0hp0VH7Lvc&list=PLGRIaa4wmIrD8RCm8Q6EWR91DCKGOub3R SQL Playlist:- https://www.youtube.com/watch?v=L3L64rf_pow&list=PLGRIaa4wmIrDtf69V6xUPUY5ELUhITepx Google Data Studio playlist:- https://www.youtube.com/watch?v=FKsK6TPJqLc&list=PLGRIaa4wmIrCBGlKMT8xJRdj3A6GVkr4A You can follow us on the below social media handles:- Blog: - https://thedatamillennials.blogspot.com/ Facebook:- https://www.facebook.com/The-Data-Millennials-596575371027542/ Instagram: - https://www.instagram.com/the_data_millennials/ LinkedIn: - https://www.linkedin.com/in/data-millennials-6b5a031b3/ Twitter: - https://twitter.com/DataMillennials