燕十八公益课程，10月29日晚作业提交

首现还是祝福18哥的公益课程越办越火~我替同学们说声，18哥辛苦了~

    长话短说。来整作业

5.4: 用友面试题 CREATE TABLE IF NOT EXISTS `match` (   `matchID` int(11) NOT NULL AUTO_INCREMENT,   `hostTeamID` int(11) NOT NULL,   `guestTeamID` int(11) NOT NULL,   `matchResult` varchar(20) NOT NULL,   `matchTime` date NOT NULL,   PRIMARY KEY (`matchID`) ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ; -- -- 转存表中的数据 `match` -- INSERT INTO `match` (`matchID`, `hostTeamID`, `guestTeamID`, `matchResult`, `matchTime`) VALUES (1, 1, 2, '3:2', '2006-06-01'), (2, 2, 4, '2:1', '2006-05-01'), (3, 1, 3, '1:2', '2006-06-14'), (4, 2, 4, '2:3', '2006-07-10'); CREATE TABLE IF NOT EXISTS `team` (   `teamID` int(11) NOT NULL AUTO_INCREMENT,   `teamName` varchar(20) NOT NULL,   PRIMARY KEY (`teamID`) ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ; -- -- 转存表中的数据 `team` -- INSERT INTO `team` (`teamID`, `teamName`) VALUES (1, '拜仁'), (2, '巴塞罗那'), (3, 'AC米兰'), (4, '皇家马德里'); 答案。 select b.teamName,a.matchResult,c.teamName,a.matchTime from `match` as a left join team as b on a.hostTeamID=b.teamID left  join team as c on a.guestTeamID=c.teamID where matchTime between '2006-6-1' and '2006-7-1';