SQL

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:
Databases / SQL DifficultyMedium SQL
The company needs a database to store information about the products, customers, and orders. The database should be able to track the quantity of products in stock and customer information so that the company can email customers updates about their orders.
About this solution: This solution is complete and solves the problem. The approach is normalized, which is optimal.
Oct 20
Databases / SQL
Given a table of transactions, this SQL query will find the total value of all transactions that occurred on each day.
About this solution: The candidate's solution is correct and solves the problem. The approach is straightforward and easy to understand.
Oct 18
Databases / SQL DifficultyMedium SQL
This problem deals with using a cursor to loop through a table of employee data in order to print the employee's name and salary.
About this solution: 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
Databases / SQL
To find the top 10 customers by total purchase amount, write a SQL query that orders the customers by purchase_amount in descending order.
About this solution: 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