Join our community to practice, learn, solve your problems with AI. Recruiters: create tests and evaluate candidates instantly.
Categories:
Code Problem
Databases
Python
Programming Languages
Mathematics
Machine Learning
NodeJS
Puzzles
Math
Algorithms
Strings
Theorems
Data structures
Games
JavaScript
More...
Recent solutions:
Check these solutions from our community:
Given a table of data with columns for name, email, and signup date, this SQL query will find the most recent signup for each email address.
About this solution: This solution is correct and demonstrates a level of completeness. It solves the problem and uses a sensible approach.
Given a table of data with columns for name, email, and signup date, this SQL query will find the most recent signup for each email address.
About this solution: This solution is correct and demonstrates a level of completeness. It solves the problem and uses a sensible approach.
Given a sorted array of integers and a target value, this function will return the index of the target value if found, or -1 if not found.
About this solution: The candidate's solution is complete and solves the problem. The candidate has used binary search, which is the most efficient way to search a sorted array for a target value.
This technical problem deals with how to write a SQL query that returns rows from a table that have been locked by another process.
About this solution: The solution correctly returns the rows that have been locked. However, it is not the most efficient solution. A more efficient solution would be to use a subquery.
Machine Learning / Data Science
DifficultyMedium
The dataset contains customer purchase histories. The task is to cluster the customers into groups based on their purchase patterns.
About this solution: The candidate's solution is complete and solves the problem. The candidate has correctly identified that k-means clustering is the best approach for this problem. This is a good general approach.
This technical problem deals with how to write a SQL query that returns rows from a table that have been locked by another process.
About this solution: The solution correctly returns the rows that have been locked. However, it is not the most efficient solution. A more efficient solution would be to use a subquery.
Machine Learning / Data Science
DifficultyMedium
The dataset contains customer purchase histories. The task is to cluster the customers into groups based on their purchase patterns.
About this solution: The candidate's solution is correct and demonstrates a level of completeness. The candidate has correctly identified the problem and proposed a solution that would solve it. The candidate's approach is sound and their solution is efficient.
Write a stored procedure that returns the top 10 products by sales from a given table.
About this solution: The candidate's solution is optimal and demonstrates a complete understanding of how to write a stored procedure to return the top 10 products by sales.