Challenge #6

Question

Consider the following employees table:

employees

Exercise

Write a SQL query to retrieve the names of employees who have a salary greater than $50,000, and list the employee names in alphabetical order.

The solution to this exercise can be found below - please take some time to work on the solution by yourself first before reading any further.

Solution

Query

Please note that the code below may not be visible if you are reading this article in your email. Kindly read the article on LinkedIn to access it.

SELECT employee_name
  FROM employees
 WHERE salary > 50000
 ORDER BY employee_name;        

Result

SQL Tips

1. Sorting Data: The ORDER BY clause is used to sort the result set in ascending (default) or descending order based on one or more columns. In this exercise, we are sorting by the employee_name column.
2. ASC and DESC Keywords: Sorting can be done in ascending order (default) by not specifying ASC, or you can explicitly specify ASC as well but it's not required; just as in our solution we preferred not to specify it. To sort in descending order, use DESC.
3. Optimizing for Readability: Use indentation and formatting to make your SQL queries more readable. Well-formatted queries are easier to understand and maintain, especially when dealing with complex statements.

Feel free to comment your findings!

If you don't want to miss the carefully crafted SQL challenges every week, subscribe to my Newsletter. Elevate your skills through practice and unlock expert tips; be on top of your game!