## Views

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

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.

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

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

119
Nov 24
##### 3rd Highest Salary in a Table

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.

170
Nov 23
##### Find the Highest Paid Employee

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

160
Nov 20
##### Find the most popular articles on a website.

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.

179
Nov 13
##### "SQL Query to Find Products with Prices Between \$10 and \$20"

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.

207
Nov 10
##### Find all employees who work in the "Sales" department.

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

222
Nov 10
##### Find the names of the two highest scoring individuals in a table of data.

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

222
Nov 08