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.
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.
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.
Find the Highest Paid Employee
AskAI
Given a table of employee data, write a SQL query to find the highest paid employee.
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.
"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.
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".
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.
