Recent solutions
Below is the list of recent solutions.
The candidate's solution is correct and uses an inner join, which is the most efficient way to find common records between two tables.
Jan 31
The solution above is optimal because it uses the ORDER BY and LIMIT clauses to sort the table by value in descending order and then return the first row.
Jan 31
The candidate's solution is correct and demonstrates a good understanding of SQL. The solution is optimal, using the ORDER BY and LIMIT clauses to sort the table by total_spend in descending order and then limit the results to the top 10 customers.
Jan 31
This solution is correct and demonstrates a level of completeness. It correctly calculates the sum of the values in table A and table B, and then multiplies them together.
Jan 30
The solution above is optimal because it uses the DISTINCT keyword to return only unique values.
Jan 30
This solution is correct and uses the XML data type's built-in methods to parse the XML data, which is optimal.
Jan 30
The solution above is optimal because it is the simplest solution that will work.
Jan 29
The solution above is optimal because it uses the COUNT function with the DISTINCT keyword. This will count the number of unique values in each column.
Jan 29