CS TECHIIE | SQL Notes and Solutions
Practical SQL exercise: Compares each salary with the overall average.
Objective
Compares each salary with the overall average.
Explanation
Read the statement clause by clause and predict the result before executing it. These examples use common relational SQL; table setup and exact syntax can vary between MySQL, PostgreSQL, SQL Server, Oracle and SQLite.
Safety check
Before running UPDATE or DELETE, run a SELECT with the same WHERE condition. Use a test database and a transaction for changes you need to verify.
Program / SQL Solution
SELECT * FROM employees WHERE salary>(SELECT AVG(salary) FROM employees);Practice and revision
- Run the example and verify the output.
- Change the input and test normal, boundary and invalid cases.
- Write the solution again without looking at the notes.
Learn • Practise • Build • Secure — CS TECHIIE
