Easy
Given the following 'employees' table:
| employee_id | name | salary | department |
|-------------|---------|--------|------------|
| 1 | Alice | 3000 | HR |
| 2 | Bob | 3500 | IT |
| 3 | Charlie | 4000 | IT |
Which SQL query retrieves employees with a salary higher than the average salary?
Author: Vincent CotroStatus: PublishedQuestion passed 2286 times
Edit
7
Community EvaluationsNo one has reviewed this question yet, be the first!
16
Update a column in an SQL table16
Which SQL keyword is used to sort the result of a SELECT statement?11
Write the SQL query to delete a column from a table17
Write a SQL query to insert data into a table19
Select only distinct values in a column using SQL11
How to delete an SQL table?41
Write a SQL query to retrieve the list of employees with a salary greater than 5100.