SQL題:給你如下表:讓你查詢出沒有選小易老師課程的所有學生CREATE TABLE `S` ( `SNO` varchar(100) COLLATE utf8mb4_bin DEFAULT '' COMMENT '學號', `SNAME` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '姓名') ENGINE=InnoDB AUTO_INCREMENT=146 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='學生關(guān)系';CREATE TABLE `C` ( `CNO` varchar(100) COLLATE utf8mb4_bin DEFAULT '' COMMENT '課程號', `CNAME` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '課程名', `CTEACHER` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '老師') ENGINE=InnoDB AUTO_INCREMENT=146 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='課程關(guān)系';CREATE TABLE `SC` ( `SNO` varchar(100) COLLATE utf8mb4_bin DEFAULT '' COMMENT '學號', `CNO` varchar(100) COLLATE utf8mb4_bin DEFAULT '' COMMENT '課程號', `SCORE` bigint(100) NOT NULL DEFAULT '0' COMMENT '成績') ENGINE=InnoDB AUTO_INCREMENT=146 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='選課關(guān)系';INSERT INTO `SC` (`SNO`, `CNO`, `SCORE`) VALUES ( '2', '11', 120);INSERT INTO `S` (`SNO`, `SNAME`) VALUES ('2', '小易');INSERT INTO `C` (`CNO`, `CNAME`, `CTEACHER`) VALUES ('11', '小易', '物理老師');Java題:給你一個字符串讓你將他反轉(zhuǎn)并轉(zhuǎn)成大寫,但“ali”這個單詞不做反轉(zhuǎn)。思路:先將所有的ali替換成特殊字符。然后正常反轉(zhuǎn),反轉(zhuǎn)后將ali替換回來