CREATE TABLE clients
	(`clID` int, `clName` varchar(5))
;
	
INSERT INTO clients
	(`clID`, `clName`)
VALUES
	(1, 'Chris'),
	(2, 'Gale'),
	(3, 'Donna')
;

CREATE TABLE scores
	(`ID` int, `clID` int, `PlayDate` datetime, `Score` numeric(10,5))
;
	
INSERT INTO scores
	(`ID`, `clID`, `PlayDate`, `Score`)
VALUES
	(1, 2, '2012-01-23 00:00:00', -0.0125),
	(2, 2, '2012-01-24 00:00:00', 0.1011),
	(3, 3, '2012-01-24 00:00:00', 0.0002),
	(4, 3, '2012-01-26 00:00:00', -0.0056),
	(5, 3, '2012-01-27 00:00:00', 0.0001),
	(6, 1, '2012-01-12 00:00:00', 0.0122),
	(7, 1, '2012-01-13 00:00:00', 0.0053)
;