120. Databricks | Pyspark| SQL Coding Interview: Employees Earning More Than Department Avg Salary
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
• 120. Databricks | Pyspark| SQL Coding Inte...
#EmployeesEarningMoreThanDeptAvg, #LeetCodeEmployeeDepartment, #LeetCodeSQL, #HackerRankSQL,#MAANG/FAANG/GAMAM,#FAANGCodingQuestion, #SQLCoding, #PysparkCoding, #CodingInterviewQuestion, #ApacheSparkInterview, #SparkCodingExercise, #DatabricksCodingInterview,#SparkWindowFunctions,#SparkDevelopment,#DatabricksDevelopment, #DatabricksPyspark,#PysparkTips, #DatabricksTutorial, #AzureDatabricks, #Databricks, #Databricksforbeginners,#datascientists, #datasciencecommunity,#bigdataengineers,#machinelearningengineers