NorthStar Air Club. The club maintains a fleet of lightairplanes and lets their members fly any airplane based on themembership level. There are three types of memberships:
Basic: 40 hours a year.
Pro: 100 hours a year.
Super: 202 hours a year.
A year runs from January 1st to December 31st. Hours cannot rollover to another year. Members can join or update their membershipany time: the hours will be prorated.
It has two departments:
Member services that enrolls members and collects memberdues.
Scheduling that keeps track of used hours and assigns aircraftsto members.
Write SQL query to updating memberinformation changing membership level with updatingnumber of hours
Expert Answer
An
OR
PayPal Gateway not configured
OR
PayPal Gateway not configured