Interview questions
Find a company or topic. Read the sources, then practice.
Loading the question library…
Find a company or topic. Read the sources, then practice.
Loading the question library…
Showing 1–6
Return each person's first and last name along with their city and state by performing a left join of Person with Address on personId, showing…
Companies: Google, Meta, Microsoft
Database
Given an ordered Logs table (id is autoincrement), identify all num values that appear in at least three consecutive rows by id and return those…
Companies: Meta
Database
Given Visits and Transactions tables, identify customers who had visits with no matching transaction records and return each customer_id with the count of such no-transaction…
Companies: Bloomberg
Database
Find all employees whose salary is among the top three distinct salaries in their department and return their department name, employee name, and salary. Include…
Companies: Intuit
Database
Given a table of students with consecutive integer ids starting at 1, return the rows where each adjacent pair of students (ids 1&2, 3&4, ...)…
Companies: Tesla, Zomato
Database
Find the second highest distinct salary from the Employee table and return it, or null if fewer than two distinct salary values exist. Essentially, retrieve…
Companies: Adobe
Database