Locking
Finding all pairs of values where one value is double the other in a SQL table
AskAI
This query will find all pairs of values in a table where one value is double the other.
SQL query to return titles of books currently checked out
AskAI
Design a SQL query that will return the titles of all books that are currently checked out from a library catalog.
Getting all rows from a table, even if some are locked.
AskAI
This technical problem deals with getting all rows from a table, even if some of the rows are locked. The solution is to write a SQL query that will return all rows from the table.
"Tracking which items in a database are currently being edited by which users"
AskAI
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 sum balances of rows with id > 5
AskAI
Write a SQL query to sum the balances of all rows with an id greater than 5.
Find all pairs of rows with overlapping start and end times.
AskAI
Given a table of data with three columns: id, start, and end, this SQL query will find all pairs of rows where the start and end times overlap.
Number of items locked by each user
AskAI
This technical problem involves writing a query to find the number of items that are locked by each user in a given table. The output should show the user ID and the number of items locked for each user.
SQL query to find names of items with price greater than or equal to $10
AskAI
Write a SQL query to find the names of all the items that have a price greater than or equal to $10.
