Commonly Asked SQL Interview Question | Exchange Seats | SQL for Data Analytics
In this video we will asked one commonly asked SQL interview question where we need to swap / exchange consecutive seats of students.
Take your SQL skills to SKY : https://www.namastesql.com/
00:00 problem statement
01:11 method 1
04:20 method 2
06:54 update statement
script:
CREATE TABLE seats (
id INT,
student VARCHAR(10)
);
INSERT INTO seats VALUES
(1, 'Amit'),
(2, 'Deepa'),
(3, 'Rohit'),
(4, 'Anjali'),
(5, 'Neha'),
(6, 'Sanjay'),
(7, 'Priya');
Zero to hero(Advance) SQL Aggregation:
https://youtu.be/5Ighj_2PGV0
Most Asked Join Based Interview Question:
https://youtu.be/xR87ctOgpAE
Solving 4 Trick SQL problems:
https://youtu.be/Ck1gQrlS5pQ
Data Analyst Spotify Case Study:
https://youtu.be/-YdAIMjHZrM
Top 10 SQL interview Questions:
https://youtu.be/Iv9qBz-cyVA
Interview Question based on FULL OUTER JOIN:
https://youtu.be/KQfWd6V3IB8
Playlist to master SQL :
https://youtube.com/playlist?l....ist=PLBTZqjSKn0IeKBQ
Rank, Dense_Rank and Row_Number:
https://youtu.be/xMWEVFC4FOk
leetcode 626. Exchange Seats
#sql #interviewquestion
