Generation

text to sql syntaxThu, 10 Nov 2022

Write an SQL query that calculates the average salary of all employees who are working in a Software Engineer position and are at most 30 years old. If there are no such employees then the answer should be NULL..

SELECT AVG(salary) FROM employees WHERE position='Software Engineer' AND age<=30;

Questions about programming?Chat with your personal AI assistant