Posts

Showing posts from March, 2023

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

Image
  --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

Restaurant Growth 7 Days Sales Average Problem Description

Image
 --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: Click here to download the SQL SCRIPT:

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

Image
  --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

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

Image
  #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: Click here to download the script

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

Image
  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***

Image
 ---SQL intreview Question Series-12 --Cricket Score board design by SQL --Asked by Facts*** Analyt*** Do check out my video for the solution. Click to download the script