Top 50 queries Interview Questions
The most frequently asked queries questions across all roles and companies, ranked by real interview frequency. Updated daily.
Calculate five-day rolling service averages using daily aggregation, a calendar join, and PostgreSQL window functions.
Exl
EXL ServicevvConstructFind how many employees joined this company during this year. Asked in the Virtual Onsite stage. SQL question asked during interview rounds. Task Write ...
Amazon
Amazon Web ServicesUse RANK and a department join to find every student tied for the highest marks in each department.
Practo
MphasisAAppianRank users by chat message frequency and return the top k with window functions and aggregation.
GoogleUse a PostgreSQL LIKE filter to find Argus employees whose names begin with the letter A.
Argus Information & Advisory ServicesAggregate ZoomInfo Engage activities by type and date, include zero-activity combinations, and calculate day-over-day changes.
ZoomInfo
ZoomInfo TechnologiesFind duplicate active client emails using a PostgreSQL CTE, JOIN, normalization, GROUP BY, and HAVING.
Ion GroupSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Preprocess a C-edge binary search tree to answer multiple sum-of-values-at-most-k queries efficiently.
C-edge