LIVE INTERVIEW - SQL Data Analyst :PART 3

Data Analyst Interviews are one of the most important parts of landing the job.
In this series we will walk through the initial Phone Interview as well as the In-Person Interview Questions.
Live Interview for Tableau Developer : PART 5
• LIVE INTERVIEW - Table...
Live Interview for Tableau Developer : PART 4
• LIVE INTERVIEW - Table...
Live Interview for Tableau Developer : PART 3
• LIVE INTERVIEW - SQL ...
Live Interview for Tableau Developer : PART 2
• LIVE INTERVIEW - Table...
Live Interview for Tableau Developer : PART 1
• LIVE INTERVIEW - Data ...

[@eddyjo3259]

Again thank You.
I can totally feel the pressure of the interview , and this is a good thing.
It actually reminds us to be ready for an interview any time.

[@CareerBreakout]

Welcome 🙂

[@ShadabKhan-de4pt]

12:15
create table tableA (No int);
create table tableB (No int);
insert into tableA values (2),(1),(null),(1),(3),(4);
insert into tableB values (1),(null),(2),(3),(2),(5);
select * from tableA;
select * from tableB;
select * from tableA as A inner join tableB as B where a.no=b.no;

[@akp558]

Nice upload more like this real live interview

[@ultra332211]

Awesome experience though pressure

[@eddyjo3259]

For this sql question 5:19
here is my answer
Select *
From
(
Select
name,
employeeID,
salary,
DoJ,
departmentID,
Row_Number over (Partition by departmentID Order by salary Desc) as position
From
employee e INNER JOIN department d
ON e.departmentID = d.departmentID
)
Where position = 3 ;

[@kariza87]

*row_number()

[@xyz-vv5tg]

We can always use dense rank instead of row number

[@saktiprasad7337]

create table CRICKET (TEAM varchar(10))
insert into CRICKET values ('INDIA')
insert into CRICKET values ('PAK')
insert into CRICKET values ('ENG')
insert into CRICKET values ('RSA')
insert into CRICKET values ('AUS')
select A.TEAM,B.TEAM from
(select *,ROW_NUMBER()over (order by TEAM) as RN from CRICKET) as A
inner join
(select *,ROW_NUMBER()over (order by TEAM) as RN from CRICKET) as B
on A.RN

[@myjourney352]

Good approach but simply joining with condition a.team_name

[@rajbest8638]

Materialised views store the result of the underlying query also in the database

[@user-bt4pz2jl6n]

in your frist quetion query where are you joining emp and dept tables?

[@motivationwithsuccess6728]

Nice information thank you

[@CareerBreakout]

Welcome 😊

[@deepanshugoyal2531]

Inner join will give 5

[@KARAN-xf2it]

I think answer of last question was delivered wrong. If I got proper data.
TABLE A
x
2
1
NULL
1
3
4
TABLE B
x
1
NULL
2
3
2
5
select * from A as a
inner join
B as b
on a.x=b.x
INNER JOIN
x x
2 2
2 2
1 1
1 1
3 3
THERE ARE 5 RECORDS SHOUL COME.

[@shaileshvadgama2105]

Who is participant in this interview?

[@bharathbablu8643]

Hey
May I know which company this is?

[@eddyjo3259]

For This sql Questions 11:15
I think the answer will a table :
2 2
2 2
1 1
3 3
as a join can include duplicates , and we cannot join on NULL values.
is there any other opinion ?

[@shwetagund9424]

2 2
2 2
1 1
1 1
3 3

[@madansmadan3632]

Null is correct

[@mohammedansar2840]

2
2
1
1
3

[@ShadabKhan-de4pt]

@@shwetagund9424
create table tableA (No int);
create table tableB (No int);
insert into tableA values (2),(1),(null),(1),(3),(4);
insert into tableB values (1),(null),(2),(3),(2),(5);
select * from tableA;
select * from tableB;
select * from tableA as A inner join tableB as B where a.no=b.no;

[@amanshukla270]

Bhaiya how did you get your 1st job...... I'm facing a lot prob here every one says They want experience......
I'm a fresher with tableau,power bi, SQL skills but no one wants to hire me....

[@CareerBreakout]

Sure, will make video on this.

[@amanshukla270]

@@CareerBreakout please make ✌️

[@Nkihgf]

if u think u r good with these skill set ?

[@vigneshwarkumaran1454]

Do internships for free and get experience with live projects for 6 months minimum.
Then you will get interviews everywhere.

[@SVP0408]

@@vigneshwarkumaran1454 where internship projects available...

[@RohitSharma-ny1oq]

bhai tra interview ho gya clear🙄🙄🙄

[@CareerBreakout]

it was old one