Expressions using Arithmetic

SELECT Name, Salary, Commission/Salary

FROM Salesperson

WHERE Commission > .05*Salary

SELECT ContactName, CompanyName

FROM Customer

WHERE Paid is null and OrderDate >= ‘1/1/99’

ORDER BY Date-InvoiceDate

SELECT ItemName, Price*1.15

FROM Product

SELECT Name, (Date-Birthdate)/365

FROM Employee

ORDER BY Name

SELECT EmpID, Hiredate+90

FROM Employee

ORDER BY Name

current system date

Previous slide

Next slide

Back to first slide

View graphic version