1) EY Data Engineer Interview Question | SQL Interview Question

No video

1) EY Data Engineer Interview Question | SQL Interview Question | Data Analyst Interview Question |

Рет қаралды 4,899

Күн бұрын

Hi,
This question was shared to me by one of my linked in followers. Please do watch it completely and let me know your thoughts.
Please find the create table and insert statement scripts below:
create table category(
Category varchar(50),
SubCategory varchar(50),
Price varchar(50) );
insert into category values('Chips', 'Bingo', 10),
('Chips', 'Lays', 40),
('Chips', 'Kurkure', 60),
('Choclate', 'Dairy Milk', 120),
('Choclate', 'Five Star', 40),
('Choclate', 'Perk', 25),
('Choclate', 'Munch', 5),
('Biscuits', 'Oreo', 120)
Please follow me on LinkedIn and reach out for any queries: / suriya-senthilkumar-3a...
Send an email to: suriya.senthil@outlook.com
#dataengineer #sql #sqlinterview #EY #datanalytics #scenario #datascience #big4 #deloite #pwc

Пікірлер: 42

@suriyas_zone 5 ай бұрын

Hi All, This video is for beginner who is planning to get a job in the data field. If you're a person who is having some good experience and planning to revise the topics then please increase speed of the video. Thanks

@Kirankumar-ml1ro Ай бұрын

Please change the data type of the price column to numeric in the create table script in the description. Data was not getting as expected while (order by price desc) for category choclate in PostgreSQL.

@anujshinde6541 13 күн бұрын

with cte as (select *,row_number() over(partition by category order by price desc) as rank,count(subcategory) over(partition by category) as count from category) select Category,SubCategory from cte where rank = 50 and count = 1;

@nishantchavan2980 2 ай бұрын

Great effort. Keep it up

@rawat7203 5 ай бұрын

with cte as( select Category, SubCategory, cast(Price as signed) as price_int from Category), cte2 as ( select Category, SubCategory, price_int, rank() over(partition by Category order by price_int desc) as rnk, count(Category) over(partition by Category) as total_cnt from cte) select * from cte2 where rnk 1 then 2 when total_cnt = 1 and price_int >= 50 then 1 end )

@suriyas_zone 5 ай бұрын

Great

@prabhatgupta6415 5 ай бұрын

with cte as (select * from (select *,dense_rank()over(partition by category order by price) dk from category)x where dk50 then 'yes' else 'no' end as flag from b )m where flag='yes';

@suriyas_zone 5 ай бұрын

Great

@ogunniransiji2686 2 ай бұрын

WHERE (rn = 50); I prefer this

@suriyas_zone 2 ай бұрын

@@ogunniransiji2686 great

@deepakchawde4180 3 ай бұрын

Amazing sir Thanks for sharing ❤

@suriyas_zone 3 ай бұрын

Thank you. Please do share and subscribe 🎉

@edumail1016 18 күн бұрын

This is so easy question, don't know how it was asked for Data Engineer role

@suriyas_zone 18 күн бұрын

@@edumail1016 Is it ? May I know how much work experience do you have in the data engineering field ? Data engineers with 1-3 years experience got this type of questions.

@MubarakAli-qs9qq 10 сағат бұрын

I have 1 month of experience

@amarpc3532 Ай бұрын

Informative ❤ and subscribed

@suriyas_zone Ай бұрын

@@amarpc3532 thank you ❤️

@shovilgupta5679 8 күн бұрын

Change the data type of price to numeric

@maheshnagisetty4485 2 ай бұрын

select category,subcategory from ( select *,rank() over(partition by category order by cast(price as money) desc) as rn from category ) as a where rn50

@suriyas_zone 2 ай бұрын

It will give the category which has single subcategories and also if it's price is less than 50. Good try...keep practicing!

@tomshri1453 5 ай бұрын

Sir.. really useful 🎉

@suriyas_zone 5 ай бұрын

Thank you

@vaibhavverma1340 2 ай бұрын

My Solution :) with cte as (select *, dense_rank() over (partition by category order by price desc)dr , count(*) over (partition by category)cnt_category from category) select category, subcategory from cte where cnt_category = 1 and price > 50 union select category, subcategory from cte where cnt_category > 1 and dr

@suriyas_zone 2 ай бұрын

Great

@piyushramkar9404 3 ай бұрын

correct me if i am wrong. --query: with cte1 as ( select category, subcategory, price, rank() over(partition by category order by price) rnk from category ) select category, subcategory from cte1 where rnk in (1,2) --output: CATEGORY SUBCATEGORY Biscuits Oreo Chips Bingo Chips Lays Choclate Dairy Milk Choclate Perk

@suriyas_zone 3 ай бұрын

Hi Piyush, Your query won't give expected results. It will give all the subcategories based on the rank(1,2) which you've generated based on category and price. What will happen if the price is less than 50 ?

@keerthianand212 5 ай бұрын

Sir window functions full explanation video podunga

@suriyas_zone 5 ай бұрын

Sure

@pathanfirozkhan5503 5 ай бұрын

Informative

@suriyas_zone 5 ай бұрын

Thanks ! Please do share with your friends. Videos will be uploaded weekly once !

@zaravind4293 5 ай бұрын

Find my approach below. select category,subcategory from ( select c.*, case when count(*) over(partition by category)=1 and price

@gouravbhatt5099 Ай бұрын

Shouldn't the price have >=50 in this query ? select category,subcategory from ( select c.*, case when count(*) over(partition by category)=1 and price>=50 then 0 else dense_rank()over(partition by category order by price desc) end rk from category c ) where rk

@mohammedvahid5099 2 ай бұрын

Nice bro

@suriyas_zone 2 ай бұрын

Thank you bro

@mohammedvahid5099 5 ай бұрын

Pleas share more with SQL scenarios pls

@suriyas_zone 5 ай бұрын

Sure. Weekly once video will be uploaded

@user-wg4bh3rv5i 5 ай бұрын

Hai can we get job in Data Engineer role as a fresher

@suriyas_zone 5 ай бұрын

Hi, Yes for sure. Definitely, a fresher can get a job as data engineer. But, many companies will not offer directly. I would recommend you to learn SQL, python, story telling, basics of data modelling, basics of Excel initially to get a job as a data analyst full-time or for the intern.. Get into the field first and try for a data engineer by learning, spark/Hadoop/hive (spark will be my choice) and one cloud. Keep an eye on my KZfaq Channel to learn more about SQL, data modelling and python.

@user-wg4bh3rv5i 5 ай бұрын

Thank you so much @@suriyas_zone