SQL Interview Question for Senior Data Engineer Position in Poland | Data Engineering

In this video we are going to discuss a SQL interview problem asked in epam systems interview for senior data engineer position. We are going solve this with inner join and left join both.

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?list=PLBTZqjSKn0IeKBQDjLmzisazhqQy4iGkb

Rank, Dense_Rank and Row_Number:
https://youtu.be/xMWEVFC4FOk

script:
CREATE TABLE [emp_salary]
(
[emp_id] INTEGER NOT NULL,
[name] NVARCHAR(20) NOT NULL,
[salary] NVARCHAR(30),
[dept_id] INTEGER
);


INSERT INTO emp_salary
(emp_id, name, salary, dept_id)
VALUES(101, 'sohan', '3000', '11'),
(102, 'rohan', '4000', '12'),
(103, 'mohan', '5000', '13'),
(104, 'cat', '3000', '11'),
(105, 'suresh', '4000', '12'),
(109, 'mahesh', '7000', '12'),
(108, 'kamal', '8000', '11');

#sql #dataengineer #interview