3. USE CarRentalCopy
GO
ALTER Table EMPLOYEE
ADD Mobile Varchar(10)

4. USE CarRentalCopy
GO
SELECT EmpNo, FirstName, DOB
FROM EMPLOYEE
WHERE LastName LIKE 'K%'
AND DOB BETWEEN '1990-1-1' AND '1990-12-31'

5. USE CarRentalCopy
go
SELECT UPPER (FirstName)+','+LastName as EmployeName
FROM EMPLOYEE

6. USE CarRentalCopy
go
CREATE View LimitedEmpl_View as
SELECT EmpNo AS EmpID,
CAST(FirstName+','+LastName as char(30)) as FullName,
HomePhone
FROM EMPLOYEE

USE CarRentalCopy
go
SELECT *
FROM LimitedEMPL_View
where EmpID<400

7. USE CarRentalCopy
go
drop view LimitedEmpl_View

8. USE CarRentalCopy
go
SELECT EmpNo, FirstName, LastName
FROM Employee
WHERE Datediff(year, DOB, GETDATE()) BETWEEN '29' AND '30'

9. USE CarRentalCopy
go
alter table  CUSTOMER
add amountdue money

USE CarRentalCopy
go
SELECT CustFirstName, CustLastName, ROUND(amountdue,0) as totaldue
FROM CUSTOMER






10.USE CarRentalCopy
go
select EmpNo, SalaryDate, Salary,
Datediff (week, SalaryDate, GETDATE()) AS EmpSalary
FROM SALARY
WHERE Datediff (week, SalaryDate, GETDATE()) > '2'


11. USE CarRentalCopy
go
Alter table CUSTOMER
ADD Gender varchar(5)

USE CarRentalCopy
go
SELECT CustNo, CustFirstName, CustLastName, Suburb, amountpaid, gender
FROM CUSTOMER
WHERE Gender = 'MALE'

USE CarRentalCopy
go
SELECT C.CustFirstName,C.CustLastName, PaymentNo, P.AmountPaid
FROM CUSTOMER C
LEFT JOIN PAYMENT P ON C.CustNo = P.CustomerNo



12. USE CarRentalCopy
go
SELECT TOP 3 *
FROM CUSTOMER
INNER JOIN PAYMENT
ON CUSTOMER.CustNo = PAYMENT.CustomerNo
WHERE AmountPaid

( SELECT AVG(AmountPaid)
FROM PAYMENT
INNER JOIN CUSTOMER ON PAYMENT.CustomerNo = CUSTOMER.CustNo
WHERE Gender LIKE 'FEMALE')


13. USE CarRentalCopy
go
create procedure SalaryIncrease1
(@percent_raise decimal (2,1))

AS

SELECT SALARY.*, (Salary +
Salary*@percent_raise) AS IncreasedSalary
FROM SALARY

EXEC SalaryIncrease @percent_raise = .15