SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
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(DATEADD(month, 6, UserData.DateUpdated)) AS Year FROM Users, UserData WHERE Users.UserNumber = UserData.UserNumber;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear