120. Databricks | Pyspark| SQL Coding Interview: Employees Earning More Than Department Avg Salary

Description

Azure Databricks Learning: Coding Interview Exercise: Pyspark and Spark SQL ================================================================================= Coding exercises are very common in most of the Bigdata interviews. It is important to develop coding skills before appearing for Spark/Databricks interviews. In this video, I have explained a coding scenario to find the employees who are earning more than their department average salary. This is also one of common coding exercise asked in MAANG/FAANG/GAMAM companies such as Google,Apple, Microsoft, Amazon, Meta etc., +----+-------+--------+-----------+ | Id | Name | Salary | Department| +----+-------+--------+-----------+ | 1 | Joe | 70000 | IT | | 2 | Henry | 80000 | HR | | 3 | Sam | 60000 | IT | | 4 | Max | 90000 | HR | +----+-------+--------+-----------+ +------+ | Name | +------+ | Joe | | Max | +------+ To get more understanding, watch this video https://youtu.be/Tjv881etqgY #EmployeesEarningMoreThanDeptAvg, #LeetCodeEmployeeDepartment, #LeetCodeSQL, #HackerRankSQL,#MAANG/FAANG/GAMAM,#FAANGCodingQuestion, #SQLCoding, #PysparkCoding, #CodingInterviewQuestion, #ApacheS…

Description from YouTube. Full content on the video page.