Categories:
Code Problem / Data Structures and Algorithms / Recursion (32)
Code Problem / Data Structures and Algorithms / Binary Search (30)
Code Problem / Data Structures and Algorithms / Linked Lists (26)
Code Problem / Data Structures and Algorithms / Backtracking (26)
Code Problem / Data Structures and Algorithms / Stacks and Queues (25)
Code Problem / Data Structures and Algorithms / Hashing (24)
Databases / SQL / Backup and Recovery (19)
Code Problem / Data Structures and Algorithms / Arrays and Strings (19)
Databases / SQL / Database Normalization (18)
Code Problem / Data Structures and Algorithms / Time Complexity (17)
Databases / SQL / Locking (16)
Databases / SQL / Replication (15)
Databases / SQL / SQL Queries (13)
Code Problem / Data Structures and Algorithms / Graphs (13)
Databases / SQL / Database Security (13)
More...
Recent solutions:
Check these solutions from our community:
You are given two tables, Table A and Table B. Your task is to write a SQL query that returns the sum of the values in Table A, multiplied by the sum of the values in Table B.
About this solution: 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.
This technical problem asks the reader to write a Python function that will sum all of the integers in a given list. An example input and output are provided.
About this solution: This solution correctly sums a list of integers. However, it is not very robust - for example, it would not work if the input was not a list of integers. Additionally, the function does not have any documentation to explain what it does or how to use it.
This stored procedure will take in a table name and column name as input, and return all the unique values in that column as output.
About this solution: The solution above is optimal because it uses the DISTINCT keyword to return only unique values.
This technical problem involves implementing a function that takes in a list of numbers and an asynchronous function, and returns a list of the results of the function applied to each number in the list.
About this solution: The candidate's solution correctly implements the function and returns the expected output. The candidate uses the asyncio library to create asynchronous tasks and wait for them to complete. This is a good approach to solving the problem.
This technical problem deals with how to query XML data in SQL in order to return it in a tabular format.
About this solution: This solution is correct and uses the XML data type's built-in methods to parse the XML data, which is optimal.
This problem involves finding the sum of all odd integers in a given list. An example input and output is provided.
About this solution: This solution is complete and solves the problem. The approach is straightforward and easy to understand.
This question asks for a cursor that will print the id, start, and end times for each row in a table. The input table has three columns: id, start, and end. The example output should print the id and start and end times for each row in the table, as shown in the example output.
About this solution: The solution above is optimal because it is the simplest solution that will work.
This technical problem deals with finding the sum of odd numbers in a list. The input is a list of integers, and the output is the sum of the odd numbers in the list.
About this solution: The candidate's solution correctly returns the sum of the odd numbers in the list. The approach is straightforward and easy to follow.