Friday, March 31, 2023

SQL Interview Questions – First and Last Call On the Same Day

 

--Problem Description –
--Ask by Subex
--SQL Interview Questions – First and Last Call On the Same Day
--Write an SQL query to report the  Callerid,Recipientid  of the users whose first and last calls on any day were with the 
--same person along with  Datecalled column


Check out my solution:



Click here to download the SQL SCRIPT


Thursday, March 30, 2023

Restaurant Growth 7 Days Sales Average Problem Description

 --Restaurant Growth 7 Days Sales Average Problem Description –
--You are the restaurant owner and you want to analyze a possible expansion (there will be at least one customer every day).
--Write an SQL query to compute the moving average of how much the customer paid in a seven days window 
--(i.e., current day + 6 days before)
--Return result table ordered by visited_on in ascending order.

Check out my solution on Youtube:



Saturday, March 4, 2023

No of rows/record generated by different types of SQL join

 

--SQL interview series 12
---Asked in most of intreview million dolar question
---No of rows/record generated by different types of join
---Joining Concept 

Download the script





Friday, March 3, 2023

#SQLIntreviewQuestion by LeadingBank|Avg distance between source and destination on multiple routes

 #SQLIntreviewQuestion by LeadingBank|Avg distance between source and destination on multiple routes





----SQL Data Analyst interview question
---Average distance between source and destination on multiple routes
--Asked by a leading Bank
Data Analyst/Business Intelligence SQL Interview Preparation Playlist:





Ungroup the given grouped data in SQL | Solving #sqlinterviewquestions#sql

 Ungroup the given grouped data in SQL | Solving #sqlinterviewquestions#sql

SQL Data Analyst Interview Question

Click to Download




Data Analyst/Business Intelligence SQL Interview Preparation Playlist:
https://www.youtube.com/playlist?list... YouTube: YouTube: https://www.youtube.com/@ArabindaMoha... LinkedIn:
LinkedIn: https://www.linkedin.com/in/arabinda-... Blog:
Blog: https://play-with-data.blogspot.com/
Tableau Public: https://public.tableau.com/app/profil... GitHub:
GitHub: https://github.com/ARBINDA765
Twitter: https://twitter.com/Rtr_Arabinda
Instagram-https://www.instagram.com/arabinda_mo...

Telegram: Join Group Chat- https://t.me/+nHjZKdHXOx04NDFl

Cricket Score board design by SQL || Asked by Facts*** Analyt***

 ---SQL intreview Question Series-12
--Cricket Score board design by SQL
--Asked by Facts*** Analyt***


Do check out my video for the solution.




"🚀 Delta Lake's Vectorized Delete: The Secret to 10x Faster Data Operations!"

"🚀 Delta Lake's Vectorized Delete: The Secret to 10x Faster Data Operations!" Big news for data engineers! Delta Lake 2.0+ in...