API tools faq
paste
Advertisement
Guest User

sdfsdfsdf

a guest
May 15th, 2019
494
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 19.33 KB | None | 0 0
raw download clone embed print report
  1. create table Flights
  2. (
  3. flightnumber varchar(30) primary key,
  4. departure varchar(30),
  5. destination varchar(30),
  6. flightdate date ,
  7. planemodel varchar(30),
  8. price int,
  9. );
  10.  
  11. create table Hotels
  12. (
  13. hotelsn varchar(30) primary key,
  14. hotelname varchar(30),
  15. country varchar(30),
  16. city varchar(30),
  17. street varchar(30) ,
  18. housenumber varchar(30),
  19. hotelrank float,
  20. price varchar(30),
  21. htraveldate date ,
  22. );
  23.  
  24. create table Clients
  25. (
  26. id varchar(30) primary key,
  27. passportid varchar(30) ,
  28. firstname varchar(30) ,
  29. lastname varchar(30) ,
  30. gender varchar(10) ,
  31. country varchar(30) ,
  32. city varchar(30) ,
  33. street varchar(30) ,
  34. birthday date ,
  35. telephone varchar(30) ,
  36. email varchar (30) ,
  37. );
  38.  
  39.  
  40. create table orders
  41. (
  42. orderid varchar(30) primary key ,
  43. dealtype varchar(30) ,
  44. dealdate date ,
  45. nights varchar(10),
  46. totalprice varchar(10),
  47. people varchar(10),
  48. );
  49.  
  50. create table flightsorder
  51. (
  52. orderid varchar(30) foreign key references orders (orderid) ,
  53. flightnumber varchar(30) foreign key references Flights (flightnumber) ,
  54. primary key(orderid , flightnumber) ,
  55. );
  56.  
  57. create table hotelsorder
  58. (
  59. orderid varchar(30) foreign key references orders (orderid) ,
  60. hotelsnumber varchar(30) foreign key references Hotels (hotelsn) ,
  61. htraveldate date,
  62. primary key(orderid , hotelsnumber,htraveldate) ,
  63. );
  64.  
  65. create table clientsorder
  66. (
  67. id varchar(30) foreign key references Clients (id) ,
  68. orderid varchar(30) foreign key references orders (orderid) ,
  69. primary key(id , orderid) ,
  70. );
  71. /*Flights for Thiland*/
  72. insert into Flights values('LY 082' , 'Ben-Gurion' , 'Bangkok - Survernabumi' , '2019/06/28' , 'Boeing 757' , '680'),
  73. ('LY 083' , 'Ben-Gurion' , 'Bangkok - Survernabumi' , '2019/06/29' , 'Boeing 767' , '670'),
  74. ('LY 084' , 'Ben-Gurion' , 'Bangkok - Survernabumi' , '2019/06/30' , 'Boeing 777' , '660'),
  75. ('LY 085' , 'Ben-Gurion' , 'Bangkok - Survernabumi' , '2019/07/01' , 'Boeing 757' , '650'),
  76. ('LY 086' , 'Ben-Gurion' , 'Bangkok - Survernabumi' , '2019/07/02' , 'Boeing 767' , '640'),
  77. /*Flights for Holland*/
  78. ('LY 337' , 'Ben-Gurion' , 'Amsterdam - Schipol' , '2019/06/28' , 'boeing 737' , '420'),
  79. ('LY 347' , 'Ben-Gurion' , 'Amsterdam - Schipol' , '2019/06/29' , 'boeing 747' , '390'),
  80. ('LY 237' , 'Ben-Gurion' , 'Amsterdam - Schipol' , '2019/07/04' , 'boeing 757' , '310'),
  81. ('LY 137' , 'Ben-Gurion' , 'Amsterdam - Schipol' , '2019/07/07' , 'boeing 767' , '430'),
  82. ('LY 546' , 'Ben-Gurion' , 'Amsterdam - Schipol' , '2019/07/09' , 'boeing 747' , '480'),
  83. /*Flights for Los Angeles*/
  84. ('LY 006' , 'Ben-Gurion' , 'Los Angeles - LAX' , '2019/07/29' , 'Dreamliner' , '990'),
  85. ('LY 016' , 'Ben-Gurion' , 'Los Angeles - LAX' , '2019/07/30' , 'Dreamliner' , '950'),
  86. ('LY 012' , 'Ben-Gurion' , 'Los Angeles - LAX' , '2019/07/31' , 'Dreamliner' , '1029'),
  87. ('LY 005' , 'Ben-Gurion' , 'Los Angeles - LAX' , '2019/08/03' , 'Dreamliner' , '1019'),
  88. ('LY 003' , 'Ben-Gurion' , 'Los Angeles - LAX' , '2019/08/08' , 'Dreamliner' , '900'),
  89. /*Flights for France*/
  90. ('TO 4970' , 'Ben-Gurion' , 'Lyon-Saint Exupéry' , '2019/04/17' , 'boeing 737 - Max' , '420'),
  91. ('TO 4870' , 'Ben-Gurion' , 'Lyon-Saint Exupéry' , '2019/04/20' , 'boeing 737 - Max' , '320'),
  92. ('TO 4650' , 'Ben-Gurion' , 'Lyon-Saint Exupéry' , '2019/04/23' , 'boeing 737 - Max' , '370'),
  93. ('TO 4660' , 'Ben-Gurion' , 'Lyon-Saint Exupéry' , '2019/04/26' , 'boeing 737 - Max' , '420'),
  94. ('TO 4520' , 'Ben-Gurion' , 'Lyon-Saint Exupéry' , '2019/04/29' , 'boeing 737 - Max' , '313'),
  95. /*Flights for Poland*/
  96. ('LY 564' , 'Ben-Gurion' , 'Warsaw - Chopin' , '2019/05/01' , 'AirBus 320' , '380'),
  97. ('LY 565' , 'Ben-Gurion' , 'Warsaw - Chopin' , '2019/05/03' , 'AirBus 320' , '319'),
  98. ('LY 566' , 'Ben-Gurion' , 'Warsaw - Chopin' , '2019/05/05' , 'AirBus 320' , '287'),
  99. ('LY 567' , 'Ben-Gurion' , 'Warsaw - Chopin' , '2019/05/07' , 'AirBus 320' , '299'),
  100. ('LY 568' , 'Ben-Gurion' , 'Warsaw - Chopin' , '2019/05/09' , 'AirBus 320' , '310')
  101. /*Hotels in Thailand*/
  102. insert into Hotels values ('052' ,'Bayshore hotel', 'Thailand' , 'Kohphangan','Ban Tai' ,'141' , '5' , '850' , '2019/06/28'),
  103. ('053' ,'Four Seasons', 'Thailand' , 'Koh Samui','Angthong' ,'219' , '4.8' , '3456' , '2019/06/29'),
  104. ('054' ,'Banyan Tree', 'Thailand' , 'Bangkok','Khet Sathon' ,'143' , '4.6' , '1252', '2019/06/30'),
  105. ('055' ,'Sino Imperial ', 'Thailand' , 'Phuket','Phuket road' ,'51' , '3.9' , '157' , '2019/07/01'),
  106. ('056' ,'Hilton', 'Thailand' , 'Pattaya','Bang Lamung' ,'333' , '4.5' , '662', '2019/07/02'),
  107. /*Hotels in Holland*/
  108. ('671' ,'Radisson Blu Hotel ', 'Holland' , 'Amsterdam','Rusland' ,'17' , '4.4' , '221', '2019/06/28'),
  109. ('672' ,'Olympic Hotel ', 'Holland' , 'Amsterdam','IJsbaanpad' ,'1076' , '4' , '419', '2019/06/29'),
  110. ('673' ,'Linden Hotel ', 'Holland' , 'Amsterdam','Lindengracht' ,'1015' , '3' , '200', '2019/07/04'),
  111. ('674' ,'Sir Adam Hotel ', 'Holland' , 'Amsterdam','Overhoeksplein' ,'7' , '4.4' , '280', '2019/07/07'),
  112. ('675' ,'City Hotel Amsterdam ', 'Holland' , 'Amsterdam','Prins Hendrikkade ' ,'130' , '3' , '170' , '2019/07/09'),
  113. /*Hotels in Los Angeles*/
  114. ('123' ,'The Beverly Hills Hotel', 'USA California ' , 'Los Angeles','Sunset Boulevard' ,'9641' , '5' , '645', '2019/07/29'),
  115. ('124' ,'The LINE Hotel', 'USA California ' , 'Los Angeles','Wilshire Boulevard' ,'3515' , '4' , '425', '2019/07/30'),
  116. ('125' ,'Hotel Angeleno', 'USA California ' , 'Los Angeles','North Church Lane' ,'170' , '4.2' , '478', '2019/07/31'),
  117. ('126' ,'Luxe City Center Hotel', 'USA California ' , 'Los Angeles','South Figueroa Street' ,'1020' , '4.6' , '512', '2019/08/03'),
  118. ('127' ,'The Jeremy Hotel ', 'USA California ' , 'Los Angeles','Sunset Boulevard' ,'8490' , '5' , '745', '2019/08/08'),
  119. /*Hotels in France*/
  120. ('134' ,'Sofitel Lyon Bellecour', 'France' , 'lyon','20 Quai Gailleton' ,'2' , '5' , '145', '2019/04/17'),
  121. ('135' ,'B&B Hôtel LYON Centre', 'France' , 'lyon','Rue Raulin' ,'7' , '3' , '99', '2019/04/20'),
  122. ('136' ,'Casa Marie', 'France' , 'lyon','rue des trois maries' ,'5' , '4' , '120' , '2019/04/23'),
  123. ('137' ,'Okko Hotels Lyon', 'France' , 'lyon','bis quai Général Sarrail' ,'6' , '4' , '130', '2019/04/26'),
  124. ('138' ,'Campanile Lyon', 'France' , 'lyon','Forum Part-Dieu' ,'31' , '3' , '110', '2019/04/29'),
  125. /*Hotels in Poland*/
  126. ('145' ,'Vienna House Mokotow', 'Poland' , 'Warsaw','Postepu' ,'4' , '4' , '60', '2019/05/01'),
  127. ('146' ,'Hampton by Hilton', 'Poland' , 'Warsaw','Wspólna' ,'72' , '4' , '120', '2019/05/03'),
  128. ('147' ,'InterContinental Warsaw', 'Poland' , 'Warsaw','Emilii Plater' ,'49' , '5' , '220', '2019/05/05'),
  129. ('148' ,'Hotel Metropol', 'Poland' , 'Warsaw','Marszałkowska' ,'99' , '3' , '50', '2019/05/07'),
  130. ('149' ,'Warsaw Marriott Hotel', 'Poland' , 'Warsaw','Al. Jerozolimskie' ,'65' , '5' , '280', '2019/05/09')
  131.  
  132.  
  133. /*Clients From Israel*/
  134. insert into Clients values ('205725567' , '305725567' ,'Osher' , 'Revach' ,'Male', 'Israel' , 'Nahariyya' , 'Hahalutz' , '1994/09/27' , '0509823235' , 'osher671@outlook.com'),
  135. ('311555114' , '405725567' ,'Yanir' , 'Itzhak' ,'Male', 'Israel' , 'Shlomi' , 'Yefe Nof' , '1993/09/21' , '0544498454' ,'yanir401@gmail.com'),
  136. ('123456789' , '789456123' ,'Haim' , 'Schwetz' ,'Male', 'Israel' , 'Tel Aviv' , 'Ben Yehuda' , '1974/01/21' , '0545556789' , 'HaimS@outlook.com'),
  137. ('456789123' , '215725547' ,'Daniel' , 'Barak' ,'Male', 'Israel' , 'Karmiel' , 'Nesher' , '1994/02/20' , '05098231235' , 'Daniel18@walla.com'),
  138. ('205725127' , '305725567' ,'Dor' , 'Peled' ,'Male', 'Israel' , 'Nahariyya' , 'Hanita' , '1994/09/10' , '0509823435' , 'Dorpe18@gmail.com'),
  139. /*Clients From USA*/
  140. ('264163639' , '204504874' ,'Athena' , ' Patterson' ,'Female', 'USA - Florida' , 'Jacksonville' , 'Boundary Street' , '2000/12/10' , ' 9046134259' , 'berneice1990@gmail.com'),
  141. ('523898454' , '829526909' ,'Dulce' , ' Artis' ,'Female', 'USA - Colorado' , 'Denver' , ' Shobe Lane' , '1980/03/19' , ' 3038172925' , 'marvin1987@gmail.com'),
  142. ('310012640' , '377653454' ,'Lucretia' , 'Jones' ,'Female', 'USA - Indiana' , 'Lafayyete' , 'Sugarfoot Lane' , '1973/03/01' , ' 3038172925' , 'alexandro1997@yahoo.com'),
  143. ('503271194' , '325233006' ,'Timothy' , 'Hayles' ,'Male', 'USA - South Dakota' , 'Pukwana' , 'Elsie Drive' , '1980/11/02' , '6052129590' , 'keaton_reil@gmail.com'),
  144. ('678015453' , '361886064' ,'Chris' , 'Lyon' ,'Male', 'USA - Arkansas' , 'Conway' , 'Masonic Hill Road' , '1978/12/16' , '5014654989' , 'tremayne_simon@hotmail.com'),
  145. /*Clients From Europe*/
  146. ('523898464' , '124526909' ,'Helmut' , ' Weber' ,'Male', 'Germany' , 'Taunusstein' , 'Witte Strase' , '1953/11/28' , '0752286818' , 'henning.susanne@freenet.de'),
  147. ('523128472' , '229556949' ,'Reinhard' , 'Zechner' ,'Male', 'Austria' , 'Grein' , 'Georg Lechner' , '1998/11/05' , '06993440551' , 'albrecht.noah@gmail.com'),
  148. ('223893254' , '129426609' ,'Hollie' , ' Grant' ,'Female', 'United Kingdom' , 'Grangetown' , 'Spilman Street' , '1939/06/27' , '07958172239' , 'HollieGrant@teleworm.us'),
  149. ('456123454' , '123545609' ,'Lucas' , ' Fitzgerald' ,'Male', 'France' , 'Paris' , 'Faubourg Saint Honoré' , '1973/10/14' , ' 0135243323' , 'LucasFitzg@gmail.com'),
  150. ('224291354' , '642326909' ,'Amber' , ' John' ,'Female', 'Holland' , 'Draaibrug' , 'Aardenburg' , '1956/02/12' , '0634973843' , 'AmberJohn@armyspy.com'),
  151. /*Clients From Asia*/
  152. ('325725512' , '205642567' ,'Xiuying' , ' Hou' ,'Male', 'Singapore' , 'Singapore' , 'Brooke Street' , '1967/09/30' , '6563421948' , 'HouHou671@outlook.com'),
  153. ('425725513' , '305642568' ,'Lingxin' , 'Kong' ,'Male', 'Hong Kong' , 'Western District' , 'Gaathon' , '1967/09/30' , '8522424382' , 'KongKing12@outlook.com'),
  154. ('525725514' , '405642569' ,'Kamaaluddeen' , 'el Mansoor' ,'Male', 'Qatar' , 'Doha' , 'Airport Road' , '1995/03/05' , '0097444416455' , 'SamiHaqatar@outlook.com'),
  155. ('022487849' , '132487849' ,'Burimas' , 'Ratana' ,'Male', 'Thailand' , 'Bangkok' , 'Rama 9 Road' , '1980/05/11' , '022480059' , 'DagBuri@PadThai.com'),
  156. ('436396916' , '129396916' ,'Embun bin' , 'Kemuning' ,'Male', 'Malasya' , 'Selangor' , 'Bandar Baru Sungai' , '1984/12/05' , '036156916' , 'FlyMalasia@Crush.com'),
  157. /*Clients From SouthAmerica*/
  158. ('125725413' , '005642537' ,'Fabio Mohamed' , ' Janssens Vilorio' ,'Male', 'Ecuador' , 'Pichincha' , 'Real del Monti' , '1990/08/06' , '9738887483' , 'auvilorio20@yopmail.com'),
  159. ('175725513' , '225642468' ,'Magdalena' , 'Cornellas' ,'Female', 'Argentina' , 'San Luis' , 'Privada Madre de Dios' , '1977/09/30' , '9491999538' , 'gemagdalenag4@yopmail.com'),
  160. ('441922482' , '189200381' ,'Nancy Resines' , 'Nabilr' ,'Female', 'Brazil' , 'Pernambuco' , 'Boulevard Farid' , '1976/10/23' , '558884002' , 'hvnabil21@yopmail.com'),
  161. ('431672451' , '023225853' ,'Pericles Mauro' , 'Lopez Louah' ,'Male', 'Colombia' , 'Sucre' , 'Calle Buenaposada' , '1987/05/21' , '8482554522' , 'periclesmauro@yopmail.com'),
  162. ('570509442' , '644819365' ,'Beltane Vial' , 'González' ,'Male', 'Peru' , 'Madre de Dios' , 'Escarp' , '1992/03/28' , '3534444919' , 'zarate12@yopmail.com')
  163.  
  164. /*Deals For Thailand*/
  165. insert into orders values ('123456789' , 'AllInclude' , '2019/06/28' ,'15', '1645' , '4'),
  166. ('123456780' , 'AllInclude' , '2019/06/29' ,'18', '1945' , '5'),
  167. ('123456781' , 'AllInclude' , '2019/06/30' ,'16', '1478' , '3'),
  168. ('123456782' , 'AllInclude' , '2019/07/01' ,'12', '1245' , '2'),
  169. ('123456783' , 'AllInclude' , '2019/07/02' ,'11', '1145' , '1'),
  170. /*Deals Order for Holland*/
  171. ('135792468' , 'Breakfast inc' , '2019/06/28' ,'5', '629' , '2'),
  172. ('135792469' , 'Breakfast inc' , '2019/06/29' ,'6', '650' , '6'),
  173. ('135792461' , 'Breakfast inc' , '2019/07/04' ,'4', '440' , '3'),
  174. ('135792462' , 'Breakfast inc' , '2019/07/07' ,'3', '329' , '2'),
  175. ('135792463' , 'Breakfast inc' , '2019/07/09' ,'7', '750' , '4'),
  176. /*Deals Order for Los Angeles*/
  177. ('111111111' , 'AllInclude' , '2019/07/29' ,'15', '1645' , '4'),
  178. ('111111112' , 'AllInclude' , '2019/07/30' ,'18', '1849' , '5'),
  179. ('111111113' , 'AllInclude' , '2019/07/31' ,'16', '1172' , '3'),
  180. ('111111114' , 'AllInclude' , '2019/08/03' ,'12', '1298' , '2'),
  181. ('111111115' , 'AllInclude' , '2019/08/08' ,'11', '1345' , '1'),
  182. /*Deals Order for France*/
  183. ('222222222' , 'Breakfast inc' , '2019/04/17' ,'4', '390' , '1'),
  184. ('222222223' , 'Flight and Hotel only' , '2019/04/20' ,'5', '320' , '3'),
  185. ('222222224' , 'AllInclude' , '2019/04/23' ,'5', '690' , '4'),
  186. ('222222225' , 'Breakfast inc' , '2019/04/26' ,'2', '310' , '2'),
  187. ('222222226' , 'Breakfast inc' , '2019/04/29' ,'2', '230' , '1'),
  188. /*Deals Order for France*/
  189. ('333333333' , 'Breakfast inc' , '2019/05/01' ,'4', '390' , '1'),
  190. ('333333334' , 'Flight and Hotel only' , '2019/05/03' ,'5', '320' , '3'),
  191. ('333333335' , 'AllInclude' , '2019/05/05' ,'5', '690' , '4'),
  192. ('333333336' , 'Breakfast inc' , '2019/05/07' ,'2', '310' , '2'),
  193. ('333333337' , 'Breakfast inc' , '2019/05/09' ,'2', '230' , '1')
  194.  
  195.  
  196. /*Flights Order for Thiland*/
  197. insert into flightsorder values ('123456789' ,'LY 082'),
  198. ('123456780' ,'LY 083'),
  199. ('123456781' ,'LY 084'),
  200. ('123456782' ,'LY 085'),
  201. ('123456783' ,'LY 086'),
  202. /*Flights Order for Holland*/
  203. ('135792468' ,'LY 337'),
  204. ('135792469' ,'LY 347'),
  205. ('135792461' ,'LY 237'),
  206. ('135792462' ,'LY 137'),
  207. ('135792463' ,'LY 546'),
  208. /*Flights Order for Los Angeles*/
  209. ('111111111' ,'LY 006'),
  210. ('111111112' ,'LY 016'),
  211. ('111111113' ,'LY 012'),
  212. ('111111114' ,'LY 005'),
  213. ('111111115' ,'LY 003'),
  214. /*Flights Order for France*/
  215. ('222222222' ,'TO 4970'),
  216. ('222222223' ,'TO 4870'),
  217. ('222222224' ,'TO 4650'),
  218. ('222222225' ,'TO 4660'),
  219. ('222222226' ,'TO 4520'),
  220. /*Flights Order for Poland*/
  221. ('333333333' ,'LY 564'),
  222. ('333333334' ,'LY 565'),
  223. ('333333335' ,'LY 566'),
  224. ('333333336' ,'LY 567'),
  225. ('333333337' ,'LY 568')
  226.  
  227. /*Thailand Hotels*/
  228. insert into hotelsorder values ('123456789' ,'052' ,'2019/06/28'),
  229. ('123456780' ,'053' ,'2019/06/29'),
  230. ('123456781' ,'054' ,'2019/06/30'),
  231. ('123456782' ,'055' ,'2019/07/01'),
  232. ('123456783' ,'056' ,'2019/07/02'),
  233. /*Holland Hotels*/
  234. ('135792468' ,'671' ,'2019/06/28'),
  235. ('135792469' ,'672' ,'2019/06/29'),
  236. ('135792461' ,'673', '2019/07/04'),
  237. ('135792462' ,'674', '2019/07/07'),
  238. ('135792463' ,'675', '2019/07/09'),
  239. /*Los Angeles Hotels*/
  240. ('111111111' ,'123', '2019/07/29'),
  241. ('111111112' ,'124', '2019/07/30'),
  242. ('111111113' ,'125', '2019/07/31'),
  243. ('111111114' ,'126', '2019/08/03'),
  244. ('111111115' ,'127', '2019/08/08'),
  245. /*France Hotels*/
  246. ('222222222' ,'134', '2019/04/17'),
  247. ('222222223' ,'135', '2019/04/20'),
  248. ('222222224' ,'136', '2019/04/23'),
  249. ('222222225' ,'137', '2019/04/26'),
  250. ('222222226' ,'138', '2019/04/29'),
  251. /*Poland Hotels*/
  252. ('333333333' ,'145', '2019/05/01'),
  253. ('333333334' ,'146', '2019/05/03'),
  254. ('333333335' ,'147', '2019/05/05'),
  255. ('333333336' ,'148', '2019/05/07'),
  256. ('333333337' ,'149', '2019/05/09')
  257.  
  258. /*Orders From Israel Client*/
  259. insert into clientsorder values('205725567' ,'123456789'),
  260. ('311555114' ,'135792468'),
  261. ('123456789' ,'111111111'),
  262. ('456789123' ,'222222222'),
  263. ('205725127' ,'333333333'),
  264. /*Order from USA Clients*/
  265. ('264163639' ,'123456780'),
  266. ('523898454' ,'135792469'),
  267. ('310012640' ,'111111112'),
  268. ('503271194' ,'222222223'),
  269. ('678015453' ,'333333334'),
  270. /*Order From Europe Clients*/
  271. ('523898464' ,'123456781'),
  272. ('523128472' ,'135792460'),
  273. ('223893254' ,'111111113'),
  274. ('456123454' ,'222222224'),
  275. ('224291354' ,'333333335'),
  276. /*Order From Asia Clients*/
  277. ('325725512' ,'123456782'),
  278. ('425725513' ,'135792461'),
  279. ('525725514' ,'111111114'),
  280. ('022487849' ,'222222225'),
  281. ('436396916' ,'333333336'),
  282. /*Order From SA Clients*/
  283. ('125725413','123456783'),
  284. ('175725513','135792462'),
  285. ('441922482','111111115'),
  286. ('431672451','222222226'),
  287. ('570509442','333333337')
  288.  
  289. /*Sheailtot*/
  290.  
  291. update Clients
  292. Set lastname = 'Pishoto'
  293. where id = 205725567;
  294.  
  295. update Flights
  296. set destination = 'John Paul II - Krakow'
  297. where flightnumber ='LY 564'
  298.  
  299. select *
  300. from Flights , Hotels , orders
  301. where flightnumber = 'LY 082' and hotelname = 'Bayshore hotel resort' and orderid = '123456789';
  302.  
  303. select *
  304. from Flights
  305. where price BETWEEN 380 AND 680;
  306.  
  307. update Hotels
  308. set housenumber = 9699
  309. where hotelsn = '123';
  310.  
  311. select *
  312. From Clients
  313. where lastname = 'Itzhak'
  314.  
  315. select *
  316. From Flights
  317. where flightdate BETWEEN '2019/05/01' AND '2019/06/28'
  318.  
  319. select *
  320. from Clients
  321. where city = 'Nahariyya'
  322.  
  323. select city,count(id)
  324. from Clients
  325. group by city
  326.  
  327. select AVG(price)
  328. from Hotels
  329. where country = 'Thailand'
  330.  
  331. select *
  332. from Hotels
  333. where country = 'Thailand'
  334.  
  335. select * ,DATEDIFF(YY,birthday,GETDATE()) AS AGE
  336. from Clients
  337. where birthday = min(DATEDIFF(YY,birthday,GETDATE()))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!