Views

Find all rows where the value is greater than the average value.
AskAI

Given a table of data with two columns, "id" and "value", this SQL query will find all rows where the value is greater than the average value.

154
Nov 28
SQL Query to Find Employees Who Have Been with the Company for More Than 5 Years
AskAI

Given a table of employee data, this SQL query will find all employees who have been with the company for more than 5 years.

95
Nov 24
3rd Highest Salary in a Table
AskAI

To find the third highest salary in a table, you can use a SQL query. For example, given the following table: | ID | Name | Salary | |---- |-------|--------| | 1 | John | 1000 | | 2 | Jane | 2000 | | 3 | Joe | 3000 | | 4 | Sarah | 4000 | | 5 | Dave | 5000 | The third highest salary would be Joe's, with a salary of 3000.

142
Nov 23
Find the Highest Paid Employee
AskAI

Given a table of employee data, write a SQL query to find the highest paid employee.

131
Nov 20
Find the most popular articles on a website.
AskAI

Write a SQL query to find the most popular articles on a website. The table "articles" contains the id, title, and views for each article. The query should return the id, title, and views for the most popular article.

150
Nov 13
"SQL Query to Find Products with Prices Between $10 and $20"
AskAI

This technical problem involves writing a SQL query to find products with prices between $10 and $20 from a given table. An example input and output is provided.

179
Nov 10
Find all employees who work in the "Sales" department.
AskAI

Write a SQL query to find the names of all employees who work in the "Sales" department, given two tables, "employees" and "departments".

191
Nov 10
Find the names of the two highest scoring individuals in a table of data.
AskAI

Write a SQL query to find the names of the two highest scoring individuals in a table of data.

192
Nov 08