Company Name YOE (Payscale) Question
ZS Associate 3 (9LPA) You have a table sales(sale_id, product_id, sale_date, amount) and products(product_id, category). Find categories where sales in 2023 increased compared to 2022
ZS Associate 3 You have a table, logins(user_id, login_date). Find all users who have logged in for at least 3 consecutive days at any time (show user_id and first day of such a streak).
Tredence 3 there is table transcation where we have all the transcation details.. find out top 5 customers by spending.. From this top 5 give me customer at index 2 and 3
Tredence 3 id val
1 A
1 A
2 A
2 B
3 B
3 B
4 A
4 A
Write a query to find out id which are associate with only one value
Tredence 3 Write an Oracle SQL query to retrieve the top 2 highest-paid employees from each department.
Delloite 3 Write a query to find the most recent order placed by each customer, including the ORDER_ID, ORDER_DATE, and TOTAL_AMOUNT.
Impetus 3 Write a SQL Query to give output like that from Input like below -
Input
1
2
3
Output
1
2
2
3
3
3
Impetus 3 eid ename status ptime
1 a in 10:00
2 b in 11:00
1 a out 11:00
2 b out 11:30
3 c in 11:00
1 a in 12:00
Write a Query to find out the employee who are in the office.
Impetus 3 write query to find out 2nd highest salary without limit or top
3 Employee_ID [8,7,8,8,8,7,7,8,8,7]add 10 where Employee_ID is 8 and subtract 5 where Employee_ID is 7 . In single statement
3 Need to find out data which is present in Employee_stg table but not present in Employee_Tgt table.
Employee_stg (id,name) (1 John) (2 Patrick) (3 Samson)
Employee_Tgt (id name) (1 John) (2 Patrick) (3 Sameer)
Winwire 6 Write a sql query to find missing numbers from a sequence

Seqnum 1 2 4 5 7 8 9 10 | | | | | | | | |