Recent posts
Get salts for given passwords in table
AskAI
SQL Problems
This technical problem involves writing a SQL query that returns the salt for a given user's password. The example input and output are provided in the body of the problem.
Designing a Database for a Library Catalog System
AskAI
SQL Problems
A library catalog system must be designed to store and maintain data on books in a library. The system must be able to track titles, authors, ISBNs, publishers, subjects, and publication dates.
"Tracking which items in a database are currently being edited by which users"
AskAI
SQL Problems
The problem is how to design a system to track which items in a database are currently being edited by which users. The input is when a user starts editing an item, and the output is who is currently editing what.
SQL Query to Find All Parents Who Have at Least One Child
AskAI
SQL Problems
This technical problem deals with writing a SQL query to find all parents who have at least one child. The example input and output are provided in the body of the problem.
Find the average salary of all employees in a company using SQL.
AskAI
SQL Problems
The average salary of all employees in a company can be found using a SQL query. For example, if the employees table contains the following columns: ID, NAME, and SALARY, the average salary can be calculated by querying the table for the average value of the SALARY column.
SQL query to sum balances of rows with id > 5
AskAI
SQL Problems
Write a SQL query to sum the balances of all rows with an id greater than 5.
SQL Query to Find Products with Price Greater than Average Price
AskAI
SQL Problems
This technical problem involves writing a SQL query to find products with a price greater than the average price of all products.
SQL Join for Two Tables with Common Column Values
AskAI
SQL Problems
This technical problem deals with finding pairs of records from two tables that have the same value for a common column.