Solving 4 Tricky SQL Problems

Ankit Bansal
Ankit Bansal
15.2 هزار بار بازدید - 2 سال پیش - In this video we will
In this video we will discuss 4 SQL problems and their solutions.

00:00 Understand the data
01:00 Problem 1 Fairly easy
03:58 Problem 2 Interesting one
07:15 Problem 3 Tricky one
13:12 Problem 4 Typical lead/lag


Most Asked Join Based Interview Question:
Most Asked SQL JOIN based Interview Q...

Data Analyst Spotify Case Study:
Data Analyst Spotify Case Study | SQL...

Top 10 SQL interview Questions:
Top 10 SQL interview Questions and An...

Interview Question based on FULL OUTER JOIN:
SQL Interview Question Based on Full ...

Playlist to master SQL :
Complex SQL Questions for Interview P...

Rank, Dense_Rank and Row_Number:
RANK, DENSE_RANK, ROW_NUMBER SQL Anal...

script:
CREATE TABLE [students](
[studentid] [int] NULL,
[studentname] [nvarchar](255) NULL,
[subject] [nvarchar](255) NULL,
[marks] [int] NULL,
[testid] [int] NULL,
[testdate] [date] NULL
)
data:
insert into students values (2,'Max Ruin','Subject1',63,1,'2022-01-02');
insert into students values (3,'Arnold','Subject1',95,1,'2022-01-02');
insert into students values (4,'Krish Star','Subject1',61,1,'2022-01-02');
insert into students values (5,'John Mike','Subject1',91,1,'2022-01-02');
insert into students values (4,'Krish Star','Subject2',71,1,'2022-01-02');
insert into students values (3,'Arnold','Subject2',32,1,'2022-01-02');
insert into students values (5,'John Mike','Subject2',61,2,'2022-11-02');
insert into students values (1,'John Deo','Subject2',60,1,'2022-01-02');
insert into students values (2,'Max Ruin','Subject2',84,1,'2022-01-02');
insert into students values (2,'Max Ruin','Subject3',29,3,'2022-01-03');
insert into students values (5,'John Mike','Subject3',98,2,'2022-11-02');


#sql #dataengineer
2 سال پیش در تاریخ 1401/02/17 منتشر شده است.
15,252 بـار بازدید شده
... بیشتر