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.
About this solution: The candidate's solution is correct and uses the optimal approach to return the 3rd highest salary.
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.
About this solution: The solution above is optimal because it uses the ORDER BY and LIMIT clauses to sort the articles by views in descending order and then limit the results to the first row.