Transactions
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:
This problem asks for a SQL query that returns the names and total amounts spent by customers who have made a purchase in the last 30 days.
About this solution: The solution above is optimal because it uses the GROUP BY clause to group the results by customer_id and name, and the SUM() function to calculate the total amount spent by each customer.
Databases / SQL
SQL
Write a SQL query to find the products with the highest price from a given table.
About this solution: The candidate's solution is correct and solves the problem. The approach is straightforward and easy to understand.
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.