Levels Tought:
Elementary,Middle School,High School,College,University,PHD
Teaching Since: | Jul 2017 |
Last Sign in: | 271 Weeks Ago, 4 Days Ago |
Questions Answered: | 1850 |
Tutorials Posted: | 1850 |
Graduate in Biology and Nutrition, MBA Finance
Florida State University
Aug-2000 - Jul-2007
Ass. Relationship Manager
Penn-Florida
Mar-2009 - Feb-2016
Write the following SQL queries for the Airline Management System on MS
Access.  You need to assume that the Current Date is December 1st, 2016 !!
1) Find the names of person who has flown at least 2 times during last 2 months.
2) Find the person paying most to fly in November
3)Â Find the most preferable flight destination in December? Â Â
4)Â Which destination has more than 1 flight in a day from Istanbul? Â
5)Â Which flight has the highest utilization in Economy Class during December?
6) Which Flight is available on Dec 25th 2016 for at least 5 people from Istanbul to London, what is the departure time?
Hel-----------lo -----------Sir-----------/Ma-----------dam----------- Â----------- -----------Tha-----------nk -----------you----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------.Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m Â----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I