Azure Data Engineering Interview Questions
Data engineering plays a critical role in the world of data science and analytics.
In this article, I will be sharing questions that I have faced during the interview process i.e., asked in product and service-based companies.
- Write an SQL query to find a day on which the weather temperature is higher than the previous day.
create table weather
(id int,
recorddate date,
temperature int);insert into weather values(1,’2015–01–01',10),(2,’2015–01–02',25),(3,’2015–01–03',20),(4,’2015–01–04',30);
select t.Id from Weather as t, Weather as y
where Datediff (t.RecordDate, y.RecordDate) =1
and t.Temperature > y.Temperature;
2. Write an SQL to get the sum of total purchases by category.
if you see the total purchases of fruits; which is the sum of banana and Apple i.e.10, similarly the total purchases of the four vegetables should be the sum of the vegetables i.e.44
So can you please write a query SQL query that will take this as input and you will have a new column that is total purchases?
