请用SQL实现如下操作: (1)查询预定11月13日,班次为1202的所有顾客姓名 (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 fromTicket Cumtomer Wh