Computer Science homework help

/in /by

 
Using the database base created in class write queries using the sql sever to do the following.
1. For every project located in ‘Huston’, list the project number, the controlling department number, and the department manager’s last name, address, and birthdate.
2. Create a virtual table
MYVIRTUAL (fname, lname, Ssn, dno, sex, wages as total numbers of hrs worked times an hour rate of GH ¢30, salary)
3. Change the last name of the employee with social security number 999887777 to Zalawa in the virtual table.
4. List all the tuples in MYVIRTUAL
5. Write a query using Join statement to list all the names of employees in the company, their Ssn, department manager’s Social Security number and wages.
6. List the names of all employees whose salaries are between Gh ¢30,000 and Gh ¢50,000 (Use sub queries)