Meta/Facebook SQL Problem (1st Round) - Data Engineer Role (Step by Step Solving).

- This question was being asked in March 2020 for the role of Data Engineer.

Problem Statement : Find the date with the highest total energy consumption from the Meta/Facebook data centers. Output the date along with the total energy consumption across all data centers.

Create Table Command :

Create table If Not Exists fb_eu_energy (date date, consumption int);

insert into fb_eu_energy (date,consumption) value ('2020-01-01',400);
insert into fb_eu_energy (date,consumption) value ('2020-01-02',350);
insert into fb_eu_energy (date,consumption) value ('2020-01-03',500);
insert into fb_eu_energy (date,consumption) value ('2020-01-04',500);
insert into fb_eu_energy (date,consumption) value ('2020-01-07',600);

Create table If Not Exists fb_asia_energy (date date, consumption int);

insert into fb_asia_energy (date,consumption) value ('2020-01-01',400);
insert into fb_asia_energy (date,consumption) value ('2020-01-02',400);
insert into fb_asia_energy (date,consumption) value ('2020-01-04',675);
insert into fb_asia_energy (date,consumption) value ('2020-01-05',1200);
insert into fb_asia_energy (date,consumption) value ('2020-01-06',750);
insert into fb_asia_energy (date,consumption) value ('2020-01-07',400);


Create table If Not Exists fb_na_energy (date date, consumption int);

insert into fb_na_energy (date,consumption) value ('2020-01-01',250);
insert into fb_na_energy (date,consumption) value ('2020-01-02',375);
insert into fb_na_energy (date,consumption) value ('2020-01-03',600);
insert into fb_na_energy (date,consumption) value ('2020-01-06',500);
insert into fb_na_energy (date,consumption) value ('2020-01-07',250);

#MetaSQLQuestions #METAInterview #MetaSQLInterview #FAANG #FacebookSQLQuestions #SQLInterviewQuestionsandanswers #sqlInterviewQuestions #MAANG