In this video we will discuss a Google Interview question based on SQL for data analyst position.
Most Asked Join Based Interview Question:
[ Ссылка ]
Data Analyst Spotify Case Study:
[ Ссылка ]
Top 10 SQL interview Questions:
[ Ссылка ]
Interview Question based on FULL OUTER JOIN:
[ Ссылка ]
Playlist to master SQL :
[ Ссылка ]
Rank, Dense_Rank and Row_Number:
[ Ссылка ]
Script:
create table company_users
(
company_id int,
user_id int,
language varchar(20)
);
insert into company_users values (1,1,'English')
,(1,1,'German')
,(1,2,'English')
,(1,3,'German')
,(1,3,'English')
,(1,4,'English')
,(2,5,'English')
,(2,5,'German')
,(2,5,'Spanish')
,(2,6,'German')
,(2,6,'Spanish')
,(2,7,'English');
#sql #dataanalyst #google #interview
![](https://i.ytimg.com/vi/35gjU7pChQk/maxresdefault.jpg)