I am using Microsoft SQL Server 2000
1. Database Tables
2. Queries using the SQL SELECT statement.
(Note: Select all of the data from both of your tables before you perform the following)
A. Choose a job_title_code: Increase all employees' salaries that have: job_title_code by 10%.
B. Choose a job_title_code in the job_title table. Increase the Minimum_salary and Maximum_salary for this job_title_code.
C. Increase all employees' salaries by 5%.
D. Choose an employee from the employee table, delete this employee.© BrainMass Inc. brainmass.com March 4, 2021, 6:06 pm ad1c9bdddf
Select * from Job_title,Employees;
Set Salary = Salary + (Salary * .10)
WHERE job_title_code = \"a\"; I don\'t know an example ...