Microsoft SQL Interview Question | Senior Data Analyst | Deepankar Pathak

📊 Mastering Microsoft SQL Interview Question 📊
Here we are going to discuss the Microsoft SQL Interview Question for the role of Senior Data Analyst, These are the same SQL Interview Questions and answers that are from the Microsoft SQL Interview Problem.
This will benefit you if you prepare for the data engineer role.
Microsoft SQL Interview Question
KPMG SQL Interview Question
Data enginee sql interview questions
Data analyst sql interview questions
Deloitte SQL Interview
data analyst interview
deloitte interview
KPMG interview
deloitte sql interview questions
big 4 sql interview questions
pwc sql interview
data analytics sql interview
data analytics
sql interview questions
sql tutorial
sql server interview questions
sql server interview questions and answers
sql interview questions and answers
top sql interview questions and answers
sql interview questions and answers in hindi
sql interview questions
sql query interview questions and answers
sql queries interview questions and answers for experienced
sql interview
sql questions and answers
top sql questions
sql interview questions for freshers
sql interview questions for beginners
sql interview questions for experienced
intermediate level sql interview questions
sql interview preparation
sql basic questions
sql questions
sql query
interview questions sql
interview question sql join
interview questions sql basic
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
SCRIPT USED:-
CREATE TABLE Weather (
ID INT,
RECORDDATE VARCHAR(512),
TEMPERATURE INT
);
INSERT INTO Weather (ID, RECORDDATE, TEMPERATURE) VALUES ('1', '01-01-2015', '10');
INSERT INTO Weather (ID, RECORDDATE, TEMPERATURE) VALUES ('2', '02-01-2015', '25');
INSERT INTO Weather (ID, RECORDDATE, TEMPERATURE) VALUES ('3', '03-01-2015', '20');
INSERT INTO Weather (ID, RECORDDATE, TEMPERATURE) VALUES ('4', '04-01-2015', '30');
INSERT INTO Weather (ID, RECORDDATE, TEMPERATURE) VALUES ('5', '05-01-2015', '12');
INSERT INTO Weather (ID, RECORDDATE, TEMPERATURE) VALUES ('6', '06-01-2015', '45');
INSERT INTO Weather (ID, RECORDDATE, TEMPERATURE) VALUES ('7', '07-01-2015', '15');
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
#dataanalytics #powerbi #sqlinterviewquestions #sql

[@varunas9784]

Thank you for sharing! Here's my attemp on SQL server: ===================================== with flagged_days as (select *, LAG(TEMPERATURE, 1) over(order by recorddate) [previous day temperature], case when temperature - LAG(TEMPERATURE, 1) over(order by recorddate) > 0 then 'Y' else 'N' end [flag] from Weather) select Id, recorddate, temperature, [previous day temperature] from flagged_days where [flag] = 'Y' =====================================

[@deepankarpathak983]

Thanks for posting 👍

[@prajju8114]

with cte_temp as ( select ID,RECORDDATE,TEMPERATURE, LAG(TEMPERATURE) OVER(order by RECORDDATE) as PREV_TEMP from Weather ), cte_2 as ( select *,row_number() over(order by temperature desc) as cnt from cte_temp ) select ID,RECORDDATE,TEMPERATURE,PREV_TEMP from cte_2 where cnt

[@user-gq6cg3ls7f]

Another Approach with cte as( select *, case when temperature > LEAD(temperature) over (order by id) then TEMPERATURE END Temp, case when temperature > LEAD(temperature) over (order by id) then LAG(temperature) over (order by id) END Pre_Temp from Weather_Fri ) select id, RECORDDATE, temp, Pre_Temp from cte where temp is not null and Pre_Temp is not null

[@HARSHRAJ-gp6ve]

with cte as( select Weather.*,LAG(temperature)OVER(ORDER BY recordDate) as x1,LAG(recordDate)OVER(ORDER BY recordDate) as x2 FROM Weather ) select id FROM cte where temperature>x1 and DATEDIFF(recordDate,x2)=1

[@Abhi4upskill]

Here is my approach let me know if any thing is missing: SELECT * FROM ( SELECT *,LAG(TEMPERATURE,1)OVER(ORDER BY ID)AS PREV_TEMP from Microsoft_SeniorDA_Weather )AS A WHERE A.TEMPERATURE > A.PREV_TEMP

[@deepankarpathak983]

I'll check and update you soon.

[@saurabhagrawal5466]

10-Oct-2024