Collections

Algorithms, Data Structures and Coding
AskAI

Technical coding problems for technical interviews. These problems are typical for most companies engineering interviews and may include algorithms, data structures and coding questions.

Dec 13
Machine Learning Engineer
AskAI

Problems and solutions for Machine Learning engineering interviews. Machine learning engineering interviews may include questions about designing machine learning systems, models and pipelines.

Nov 06
SQL Problems
AskAI

SQL problems from technical interviews at top technology companies. These problems apply to interviews for SQL developers, database administrators.

Feb 01

Recent solutions

Below is the list of recent solutions.
The solution is optimal because it uses the GROUP BY clause to group the rows by customer_id and then uses the SUM function to sum the revenue for each customer.
Nov 04

This solution is complete and solves the problem. The approach is straightforward and easy to follow.
Nov 04

The candidate's solution correctly finds the 5th highest salary from the "Employees" table. The solution uses the correct SQL syntax and demonstrates a good understanding of the problem.
Nov 04

The candidate's solution correctly finds the 5th highest salary from the "Employees" table. The solution uses the correct SQL syntax and demonstrates a good understanding of the problem.
Nov 04

The candidate's solution correctly returns the data in the table in ascending order of id. The solution is complete and solves the problem. The approach is straightforward and easy to understand.
Nov 04

This solution is incomplete because it does not account for email addresses that may have more than one '@' character. A more complete solution would use a regular expression to match email addresses.
Nov 03

The candidate's solution correctly returns the data in the table in ascending order of id. The solution is complete and solves the problem. The approach is straightforward and easy to understand.
Nov 02

The candidate's solution correctly finds the 5th highest salary from the "Employees" table. The solution uses a with statement to create a rating table, which is then used to select the 5th highest salary. This is a valid approach and the solution correctly solves the problem.
Nov 02