. Consider the following relational schema. Employees(EmployeeID, EmployeeName, Street, City, State, Zip) Salaries(EmployeeID, JobID, Year, Department, Salary)...
Fantastic news! We've Found the answer you've been seeking!
Question:
. Consider the following relational schema. Employees(EmployeeID, EmployeeName, Street, City, State, Zip) Salaries(EmployeeID, JobID, Year, Department, Salary) Give a single SQL query that returns employee names and salaries where salaries are between 25000 and 75000 for the year 2020.
Related Book For
Database management systems
ISBN: 978-0072465631
3rd edition
Authors: Raghu Ramakrishan, Johannes Gehrke, Scott Selikoff
Posted Date: