State the SQL code for the following statements 1. Retrieve the salary of every employee 2. Retrieve
Fantastic news! We've Found the answer you've been seeking!
Question:
State the SQL code for the following statements
1. Retrieve the salary of every employee
2. Retrieve the total number of employees in the company.
3. Retrieve the total number of employees in the Software department and salary is more than 50,000.
4. Retrieve a list of employees and the projects they are working on, ordered by department and, within each department, ordered alphabetically by last name, first name
5. For every project located in 'Houston', retrieve project number, department number and department manger first name and date of birth.
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date: