premier league stats | google | ZS interview questions and answer sql
premier league stats
google interview questions and answer sql
ZS interview questions and answer sql
Create Table Code :
================
Create table If Not Exists Teams
(
team_id int,
team_name varchar(20)
);
truncate table teams;
Create table If Not Exists Matches
(
home_team_id int,
away_team_id int,
home_team_goals int,
away_team_goals int
);
insert into Teams (team_id, team_name) values
('1', 'CSK'),
('4', 'RCB'),
('6', 'KKR');
insert into Matches (home_team_id, away_team_id, home_team_goals, away_team_goals) values
('1', '4', '0', '1'),
('1', '6', '3', '3'),
('4', '1', '5', '2'),
('6', '1', '0', '0');
Need Help ? Connect With me 1:1 - https://topmate.io/dewithdhairy
Let's connect on LinkedIn : / dhirajgupta141
top interview question and answer in pyspark :
• top interview questions and answers in pys...
PySpark Installation and Setup : • Spark Installation | PySpark Installation ...
DSA In Python Interview Series : • dsa for data engineer | dsa for data analy...
PySpark Interview Series : • pyspark interview questions and answers
Pandas Interview Series : • pandas interview questions and answers
SQL Interview Series : • sql interview questions and answers
#microsoft #codingninjas #sql #dataengineers #pivot #zs #fang #pyspark #sql #interview #dataengineers #dataanalytics #datascience #StrataScratch #Facebook #data #dataengineeringinterview #codechallenge #datascientist #pyspark #CodingInterview
#dsafordataguy #dewithdhairy #DEwithDhairy #dhiarjgupta #leetcode #topinterviewquestion