请用SQL实现如下操作: (1)查询预定11月13日,班次为1202的所有顾客姓名 (2)查询给顾客王军预定机

Question

请用SQL实现如下操作：

(1) 查询预定11月13日，班次为1202的所有顾客姓名

(2) 查询给顾客王军预定机票的售票员姓名

(3) 查询顾客王军的住址、所订机票班次、日期和目的地

(4) 添加顾客记录：张华，编号：2005110912，地址：北京，班次：2203，日期11月22日

(5) 调整班次为1401的所有飞机价格，下调10％

(6) 给表Customer添加一列：姓别Ssex。

Answer 1

正确答案：(1)SELECT Cname FROM Cumtomer WHERE Cdate = '2005 - 11 - 13' and Cflightno = '1202'; (2)SELECT Sname from Seller Cumtomer Where Seller. Seustomerno = Customer. Cno (3) SELECT Caddr Cflightno Cdate Tdest from Ticket Cumtomer Where Ticket. Cnightno = Customer. Cflightno and Ticket. Tdate = Customer. Cdate (4) INSERT INTO Customer (Cno Cname Caddr Cflightno Cdate) VALUES ( 2005110912 '张华' '北京' 2203' 2005 - 11 - 22' ); (5) UPDATE Tprice SET Tprice = 0.9 * Tprice WHERE Tflightno = '1401'; (6) ALTER TABLE Customer ADD Csex char(2)
(1)SELECT Cname FROM Cumtomer WHERE Cdate = '2005 - 11 - 13' and Cflightno = '1202'; (2)SELECT Sname from Seller, Cumtomer Where Seller. Seustomerno = Customer. Cno (3) SELECT Caddr, Cflightno, Cdate, Tdest from Ticket, Cumtomer Where Ticket. Cnightno = Customer. Cflightno and Ticket. Tdate = Customer. Cdate (4) INSERT INTO Customer (Cno, Cname, Caddr, Cflightno, Cdate) VALUES ( 2005110912, '张华', '北京', 2203,' 2005 - 11 - 22' ); (5) UPDATE Tprice SET Tprice = 0.9 * Tprice WHERE Tflightno = '1401'; (6) ALTER TABLE Customer ADD Csex char(2)