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

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 from technical interviews at top technology companies. These problems apply to interviews for SQL developers, database administrators.

Feb 01

Below is the list of recent solutions.

The candidate's solution is complete and solves the problem. The approach is sensible and would likely work well in practice.

Oct 16

The candidate's solution is complete and solves the problem. The candidate has used a cursor to loop through the table and print the employee's name and salary. This is the optimal solution.

Oct 13

The candidate's solution is complete and solves the problem. The candidate has correctly identified the k-means algorithm as a suitable solution for this problem. The candidate has also correctly identified some of the benefits and drawbacks of using the k-means algorithm.

Oct 12

The candidate's solution is correct. They have provided the adjacency matrix and have correctly found the number of 3 step walks and the generating function for walks from points 1-3.

Oct 12

The candidate's solution is correct. They have provided the adjacency matrix and have correctly found the number of 3 step walks and the generating function for walks from points 1-3.

Oct 12

The solution is optimal because it uses the ORDER BY clause to sort the table by purchase_amount in descending order, and then uses the LIMIT clause to return the first 10 rows.

Oct 10