In this video we will discuss a complex data engineering problem asked in Google. In this problem we have to find all pairs of seats that are both adjacent and available.
Output only distinct pairs of seats in two columns such that the seat with the lower number is always in the first column and the one with the higher number is in the second column.
Link to the dataset
https://github.com/Hitesh-Damani/datascience_interviews_dataset/blob/951e1010396984b89f94da9d905f87f5ab2cf8b3/theater_seatmap.csv
https://github.com/Hitesh-Damani/datascience_interviews_dataset/blob/951e1010396984b89f94da9d905f87f5ab2cf8b3/theater_availability.csv
--------------------------------------------------------------------------------------------------
Support me by subscribing to my channel so that I can upload these kind of videos
https://www.youtube.com/@hiteshdamani30
#sql #dataanalysts #datascienceinterview #sqlinterviewquestions #ai #sqlfordatascience #sqlforbeginners #dataengineers #googleinterview
