EXL Analytics SQL Interview Question | 2 Different Ways of using Window Functions

Опубликовано: 26 Октябрь 2024
на канале: Ankit Bansal

11,995

430

In this video we will solve a SQL interview question asked in EXL Analytics Company.
Here are the timestamps :
00:00 Understand the problem
00:53 Solution 1
06:20 Solution 2

Data Analytics SQL interview Questions : https://www.namastesql.com/coding-pro...

script:
CREATE TABLE city_population (
state VARCHAR(50),
city VARCHAR(50),
population INT
);

-- Insert the data
INSERT INTO city_population (state, city, population) VALUES ('haryana', 'ambala', 100);
INSERT INTO city_population (state, city, population) VALUES ('haryana', 'panipat', 200);
INSERT INTO city_population (state, city, population) VALUES ('haryana', 'gurgaon', 300);
INSERT INTO city_population (state, city, population) VALUES ('punjab', 'amritsar', 150);
INSERT INTO city_population (state, city, population) VALUES ('punjab', 'ludhiana', 400);
INSERT INTO city_population (state, city, population) VALUES ('punjab', 'jalandhar', 250);
INSERT INTO city_population (state, city, population) VALUES ('maharashtra', 'mumbai', 1000);
INSERT INTO city_population (state, city, population) VALUES ('maharashtra', 'pune', 600);
INSERT INTO city_population (state, city, population) VALUES ('maharashtra', 'nagpur', 300);
INSERT INTO city_population (state, city, population) VALUES ('karnataka', 'bangalore', 900);
INSERT INTO city_population (state, city, population) VALUES ('karnataka', 'mysore', 400);
INSERT INTO city_population (state, city, population) VALUES ('karnataka', 'mangalore', 200);

Zero to hero(Advance) SQL Aggregation:
   • All About SQL Aggregations | SQL Adva...

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

Solving 4 Trick SQL problems:
   • Solving 4 Tricky SQL Problems

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

#sql #dataengineer