Hospitals Again...

To complete the SQL for the following questions using the attached database (suitable to run in Microsoft Access 2000) urgently as my last bid was not completed by the selected coder. Q1. Produce SQL that gives for each ward its name, code and the percentage of beds currently occupied in the ward. Q2. List all data from the person table about persons who are neither staff nor patients. Q3 Required to add a payments table to the database. Including the following data: admission_id payment_date amount_paid 205 16/3/92 1000 205 16/4/92 1000 274 10/10/94 600 274 10/12/94 600 279 22/11/94 390 Assumptions: Only one payment can be made per day for a particular admission. A payment is for one admission only. If a patient wishes to pay for several admissions it is regarded as separate payments. A person may make a partial payment. For the patients who have discharged but have not paid their ward bill, list the patients_id, first_name, surname, ward_name, admission_date and amount owing. ## Deliverables Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased. ## Platform Access 2000 ## Deadline information This needs to be completed urgently, but shouldnt take long to do.