115. Databricks | Pyspark| SQL Coding Interview: Number of Calls and Total Duration

Azure Databricks Learning: LeetCode 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 calculate the number of calls and total call duration between 2 persons. This is Leet Code SQL Exercise number 1699. This is also one of common coding exercise asked in MAANG/FAANG/GAMAM companies such as Google,Apple, Microsoft, Amazon, Meta etc.,

To get more understanding, watch this video

#LeetCodeSQL-1699, #LeetCodeSQL, #HackerRankSQL,#MAANG/FAANG/GAMAM,#FAANGCodingQuestion, #GoogleCodingSQL, #AmazonCodingSQL, #MicrosoftCodingSQL,#SQLSeatsExchange,#PysparkSeatsExchange, #CodingInterviewQuestion, #ApacheSparkInterview, #SparkCodingExercise, #DatabricksCodingInterview,#SparkWindowFunctions,#SparkDevelopment,#DatabricksDevelopment, #DatabricksPyspark,#PysparkTips, #DatabricksTutorial, #AzureDatabricks, #Databricks, #Databricksforbeginners,#datascientists, #datasciencecommunity,#bigdataengineers,#machinelearningengineers

[MaheshReddyPeddaggari]

Excellent explanation, Please provide more like this

[harishmkr]

select from_id, to_id, sum(duration), count(*) from (select *
from calls

union all

select to_id, from_id, duration
from calls) a

where from_id >to_id
group by 1, 2;

[venkatasai]

Good explanation Raja . Please post more questions like this .really helpful .

[lalithroy]

Hi Raja could you please make a video on delta live tables.... Pipeline