Locking
SQL query for employees with more than 5 years of tenure
AskAI
This technical problem involves writing a SQL query to return the names of employees who have been with the company for more than 5 years.
SQL query to find all pairs of rows where the values in the columns are equal
AskAI
This technical problem asks for a SQL query to find all pairs of rows in a table where the values in the two columns are equal. The example input and output show what such a query would return.
Update table rows with status 0 to 1
AskAI
This technical problem deals with updating rows in a table with a status of 0 to 1. The table is locked for writing, the rows are updated, and then the table is unlocked.
SQL Query to Sum Orders by Product ID
AskAI
This technical problem deals with writing a SQL query that returns the sum of all orders for each product_id. The given table has a schema with three columns: order_id, product_ id, and quantity. An example input and output is also provided.
Rows locked by another process
AskAI
This technical problem deals with how to write a SQL query that returns rows from a table that have been locked by another process.
Finding Employees Who Have Worked on Multiple Projects
AskAI
This technical problem deals with finding employees who have worked on multiple projects. A SQL query is provided that returns the names of all employees who have worked on at least two projects.
Find products locked for more than 3 days
AskAI
Write a SQL query to find the products that have been locked for more than 3 days.
Find the customer with the most orders.
AskAI
This technical problem involves finding the customer with the most orders in a given table. The table consists of customer order information, including customer id, order date, etc. The goal is to write a SQL query to identify the customer with the most orders.
