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.
Given a table of employee data, this SQL query will find all employees who have been with the company for more than 5 years.
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.
Given a table of employee data, write a SQL query to find the highest paid employee.
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.
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.
Write a SQL query to find the names of all employees who work in the "Sales" department, given two tables, "employees" and "departments".
Write a SQL query to find the names of the two highest scoring individuals in a table of data.