Databases / SQL / Database Normalization
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:
The goal is to find the average price of all products in the "Electronics" category. To do this, we can write a SQL query that returns the average price of all products in the "Electronics" category.
About this solution: The solution is correct and uses the WHERE clause to filter the results to only the products in the "Electronics" category.
This technical problem involves finding the second highest salary in a table. An example input and output is provided.
About this solution: The candidate's solution is correct and demonstrates a good understanding of SQL. The candidate has taken a good approach to solving the problem and has provided a complete solution.
Databases / SQL
SQL
This technical problem deals with finding all products that cost more than $10 from a list of products and their prices.
About this solution: The candidate's solution is correct and demonstrates a good understanding of SQL. The solution is also optimal, as it is simple and easy to understand.
This technical problem deals with finding all products that cost more than $10 from a list of products and their prices.
About this solution: The candidate's solution is correct and demonstrates a good understanding of SQL. The solution is also simple and easy to understand, which is always a good thing.
Write a SQL query to find the average price of all products in a database table.
About this solution: The candidate's solution is correct and demonstrates a level of completeness. The candidate's approach is also optimal, as it is the simplest way to get the average price of all products.
Write a SQL query to find the average price of all products in a database table.
About this solution: The candidate's solution is correct and demonstrates a level of completeness. The candidate's approach is also optimal, as it is the simplest way to get the average price of all products.
This technical problem involves writing a SQL query that returns the total revenue for each customer. The table schema is provided, and an example input and output are also given.
About this solution: The solution is optimal because it uses the GROUP BY clause to group the rows by customer_id and then uses the SUM function to sum the revenue for each customer.
Write a SQL query that returns the total quantity of each product ordered by each customer.
About this solution: This solution is complete and solves the problem. The approach is straightforward and easy to follow.