LatentView Analytics Very Tricky SQL Interview Question | SQL Question for Data Engineering
LatentView Analytics Very Tricky SQL Interview Question | SQL Question for Data Engineer
In this video, I will show you how I solved a very tricky SQL interview question asked to me by LatentView Analytics .
Input:
with data as (
select "A" as class, "Maths" as sub union all
select "B", "English" union all
select "A", "Social" union all
select "B", "Chemistry" union all
select "A","Physics" union all
select "B", "Statistics" union all
select "A", "Biology" union all
select "B", "Maths" union all
select "A", "Science" union all
select "B", "Social"
)
Output:
-- Class Sub1 Sub2 Sub3 Sub4 Sub5
-- A Science Physics Social Maths Biology
-- B English Social Maths Statistics Chemistry
On this page of the site you can watch the video online LatentView Analytics Very Tricky SQL Interview Question | SQL Question for Data Engineering with a duration of hours minute second in good quality, which was uploaded by the user DataTechWhiz 22 August 2024, share the link with friends and acquaintances, this video has already been watched 1,602 times on youtube and it was liked by 42 viewers. Enjoy your viewing!
