SELECT * FROM Employees WHERE Salary > 75000 ORDER BY Salary DESC; Exercise 3: Aggregates Goal: Find the average salary of all employees. Your Code: SELECT AVG(Salary) FROM Employees; 4. Quick Tips for Success
Find all employees with a salary over 75,000, sorted from highest to lowest. SQL: with practice exercises, Learn SQL Fast
SQL isn't case-sensitive ( select is the same as SELECT ), but writing keywords in CAPS makes your code easier to read. SELECT * FROM Employees WHERE Salary > 75000