I need help figuring out these codes. I have the table loaded and the data inputted. I can't figure these out.

2. Display a list of all patients who have an alternate/cell phone number

Patient First Name, followed by a space, followed by the patients last name. (e.g. Melesa Poole), alternate/cell phone number

Sort order: Patient First Name ascending

Patient Last Name ascending

3. Display a list of all patients who do not have an email address. Patient First Name, followed by a space, followed by the patients last name. (e.g. Melesa Poole)

Sort order: Patient First Name ascending

Patient Last Name ascending

4. Display a list of all patients who live in zipcode 24551. Patient Last Name, Address1, Address2, City, State, Zip

Sort order: Patient Last Name descending

5. Display a list of all physicians whose specialty is Internal Medicine or Orthopedics Physician First Name, space, last name (call this column Physician), Specialty

Sort order: Physician First Name ascending

Physician Last Name descending

6. Display a list of all physicians, their specialties, and their practices Physician Last Name, Specialty, Practice

Sort order: Physician Specialty ascending

Physician Last Name ascending

Practice ascending

7. Display a list of all physicians whose practices are in Lynchburg Physician Last Name, Practice Name, Address, City, State, Zipcode, Phone

Sort order: Zipcode ascending

Practice Name descending

Physician Last Name ascending

8. Display the number of physicians in each specialty Specialty, number of physicians in each specialty

Sort order: Specialty

9. Display the number of physicians in each practice, broken out by specialty Practice, Specialty, number of physicians in each

Sort order: Practice ascending

Specialty -- ascending

10. Display the list of specialties that have no physicians assigned to them. Specialty

Sort order: Specialty ascending

11. Display a list of all referrals whose start date was in 2013. Patient first name, followed by a space, followed by patient last name (Call this whole field Patient Name), Referring Physician Last Name (call this field Physician), StartDate, EndDate

Sort Order: StartDate ascending

Patient First Name ascending

Physician Last Name - ascending

12. Display a list of all the referrals whose start date is between October 1, 2014 and November 5, 2014 Patient first name, followed by a space, followed by patient last name (Call this whole field Patient Name), Referring Physician Last Name (call this field Physician), StartDate, EndDate

Sort Order: StartDate ascending

Patient First Name ascending

Physician Last Name - ascending

13. Display the number of referrals given by each physician Physician Last name, Physician First Name, number of referrals

Sort Order: Physician Last Name ascending

Physician First Name ascending

14. List the number of referrals in 2014 for each service requested. Service name, number of referrals

Sort order: Service name

15. Display a list of all patients requiring exercise therapy in 2013 Patient Last Name, Patient First Name

Sort order: Patient last name ascending

Patient first name ascending

16. Display a list of any referrals that require Insulin injections and 2x Daily is NOT listed as their frequency. Patient Last Name, Physician Last Name, referral start date

Sort order: Physician Last Name ascending

Patient Last Name ascending

Referral Start Date ascending

17. Display the contracts and payment methods associated with each referral Patient Last Name, Physician Last Name, Referral Start Date, Contract Start Date, Payment Method

Sort Order: Payment Method - ascending

Physician Last Name ascending

Patient Last Name ascending

Referral Start Date ascending

Contract Start Date ascending

18. Display the number of contracts whose payment method is Insurance Number of contracts (This is a single value)

19. Display the number of contracts whose payment method is Insurance, broken out by Insurance Company Insurance Company Name, number of contracts

Sort order: Insurance company name

20. List the Employees who are Nurses Employee First Name, followed by a space, followed by Employee Middle Initial, followed by a space, followed by Employee Last Name (call this whole field Nurses)

21. Display the average hourly wage for all employees who are aides. Average hourly wage (single value)

22. Display the average hourly wage for all hourly employees broken out by level. Skill level, average wage

Sort order: Skill Level

23. Display the total salary for all salaried employees. Total salaries (single value)

24. Display the number of employees assigned to each rank. RankID, Employee Type, Skill Level, Employee Title, number of employees

Sort Order: RankID ascending

Employee type ascending

Skill Level ascending

Employee Title ascending

25. Display a list of Employees who are nurses and were available to work on Sunday evenings during the week of 11/2/2014 Employee Last Name, Employee First Name

Sort order: Last Name ascending

First Name ascending

26. Display a list of Employees who were available to work during morning shifts during the week of 11/2/2014 and had a skill level of level 3. Employee Last Name, Employee First Name,

Employee Type, Employee Title

Sort order: Employee Type ascending

Employee Title ascending

Employee Last Name ascending

Employee First Name ascending

27. Display the total quantity of catheters added to inventory during 2013. Total catheters (single value)

28. Display the total cost of sterile gloves small provided by Pooles Medical supplies during 2013. Total cost (single value)

29. Display the average cost of supplies for each supply item broken out by supplier. Supply, Supplier, Average cost per supply item

Sort order: Supply ascending

Supplier ascending

30. Display the total cost of all items purchased from suppliers broken out by supplier. Supplier, Total cost of all items provided by supplier

Sort order: Supplier ascending

31. Display a list of all the visits that occurred from March 20, 2014 to March 25, 2014 (including March 20 and March 25) DateRendered, Patient Last Name, Employee Last Name, Start Time, End time

Sort order: DateRendered ascending

Patient Last Name ascending

Employee Last Name ascending

Start Time ascending

32. List the total charges for the visit that occurred on 2/12/2014 for Helen Ramirez that was provided by Laura White.

Total charges (single value)

33. List the number of patients who received insulin injections during 2014 (Note this is the number of unique patients who ever received insulin injections not the number of visits in which insulin injections were provided). Total number of patients (single value)

34. List the total number of 4 self-adhesive bandages that were used in 2014 Total number of 4 self-adhesive bandages (single value)

35. List the average charge per visit per month in 2013 broken out by months Month, average cost per visit

Sort order: month number - ascending

36. Provide a unique list of patients who received visits for feeding from November 1, 2014 until the current date. Patient Last Name, Patient First Name

Sort order: Patient Last Name ascending

Patient First Name ascending