SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE Users ( `UserNumber` int, `FirstName` varchar(10), `LastName` varchar(10) ); INSERT INTO Users ( `UserNumber`, `FirstName`, `LastName` ) VALUES (1003456, 'Bugs', 'Bunny'), (1003457, 'Minnie', 'Mouse'), (1003458, 'Yosemite', 'Sam'), (1003459, 'Daisy', 'Duck'), (1003460, 'Fred', 'Flintstone'); CREATE TABLE CareerInfo ( `InfoNumber` int, `InfoType` varchar(10), `InfoName` varchar(21), `InfoAmountType` varchar(13), `InfoAmount` int ); INSERT INTO CareerInfo ( `InfoNumber`, `InfoType`, `InfoName`, `InfoAmountType`, `InfoAmount` ) VALUES ( 2003457, 'Occupation', 'Accountants', 'YearlyWage', 67109 ), ( 2003458, 'Occupation', 'Mining Engineer', 'YearlyWage', 69780 ), ( 2003459, 'School', 'Oregon State', 'YearlyTuition', 8715 ), ( 2003460, 'School', 'Reed College', 'YearlyTuition', 51850 ), ( 2003461, 'Occupation', 'Lawyer', 'YearlyWage', 115820 ), ( 2003462, 'Occupation', 'Farm and Ranch Worker', 'YearlyWage', 27840 ); CREATE TABLE UserData ( `UserNumber` int, `InfoNumber` int, `DateUpdated` varchar(10), `Quarter` varchar(7) ); INSERT INTO UserData ( `UserNumber`, `InfoNumber`, `DateUpdated`, `Quarter` ) VALUES ( 1003458, 2003459, '2014-10-31', 'Q4 2014' ), ( 1003457, 2003461, '2015-11-02', 'Q4 2015' ), ( 1003458, 2003462, '2016-11-03', 'Q4 2016' ), ( 1003457, 2003460, '2016-11-03', 'Q4 2016' ), ( 1003456, 2003459, '2016-11-03', 'Q4 2016' ); SELECT CONCAT( Users.FirstName, ' ', Users.LastName ) AS FullName, year(date_add(month, -6, UserData.DateUpdated)) AS FiscalYear FROM Users, UserData WHERE Users.UserNumber = UserData.UserNumber;