Exercise 10.4

(1) From the Person table, display all the persons with a first name of roger:

SELECT LastName FROM Person WHERE FirstName = 'roger'


(2) From the Person table, display all the persons with an enrolment date greater than 2003-12-01

SELECT LastName FROM Person WHERE EnrolmentDate > '2003-12-01'

NOTE : with dates the best way to represent dates in php and storing them in database is to use the format of  yyyy-mm-dd  This format is a universal format.


(3) From the Person table display all the persons with no hirehdate

SELECT * FROM Person WHERE HireDate IS NOT NULL;


(4) From the person table display all the persons whose last name starts with a letter a

SELECT * FROM Person WHERE `LastName` LIKE 'a%'