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
• 115. Databricks | Pysp...
#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
When Otherwise(Case) - • 12. Databricks | Pyspa...
Greatest vs Least - • 50. Databricks | Pyspa...

[@MaheshReddyPeddaggari]

Excellent explanation, Please provide more like this

[@rajasdataengineering7585]

Sure Mahesh, will add more SQL interview series

[@harishmkr3156]

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;

[@sravankumar1767]

Superb explanation Raja 👌 👏 👍

[@rajasdataengineering7585]

Thanks Sravan

[@venkatasai4293]

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

[@rajasdataengineering7585]

Sure Venkat, will post more videos on this coding series

[@lalithroy]

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

[@rajasdataengineering7585]

Hi Lalith, yes sure I can create videos on delta live tables soon

[@sairam-vh7ro]

Hi Raja..How can we reach you?