Sql queries

Sairam3737
Assignment1RawPatientData.xlsx

Sheet1

Appointment # Patient First Name Patient Last Name Health Card # Patient DOB Patient Gender Patient Street Patient City Patient Province Patient Postal Code PatientPhone Appointment Date Reminder Required? Reason For Visit Visit Length Medication Prescribed Visit Notes Bill Amount Bill Date
10004 Jennifer Roberts 12345352 1-Sep-88 F 123 West St Kitchener ON N1N 1N1 519-555-1423 4/1/19 13:20 Yes Cold 20 Mins Antibiotics Heavy cough, she has had symptoms for more than a week $ 1,200.00 4/4/19 18:00
10005 Bob Smith 942384098 4-Aug-70 M 456 East St Kitchener ON N1N 1N1 519-432-4414 4/1/19 13:50 No Knee Pain 30 Mins Suggested stretching exercises and using heat at night $ 1,800.00 4/4/19 18:00
10006 Henry Stevens 948114 5-Jan-64 M 789 South St Cambridge ON N1N 1N1 519-456-5253 4/1/19 14:20 Yes Eye Infections 15 Mins Eye Drops Has abnomal redness in left eye. Complained about dryness for last month $ 1,000.00 4/4/19 18:00
10007 Susan Corners 9832098 22-Mar-88 F 774 North St Cambridge ON N1N 1N1 519-989-9342 4/1/19 14:50 Yes Physical 30 Mins Routine check-up. Is in great health and will be back next year for follow-up $ 1,800.00 4/4/19 18:00
10008 Harriet Spyers 764234 11-May-00 F 84 Main St W Waterloo ON N1N 1N1 519-758-0742 4/1/19 15:20 Yes Pregnancy Follow-up 15 Mins Folic Acid Patient is approximately 8 Weeks Pregnant $ 1,000.00 4/4/19 18:00
10009 Fred Sommers 62378213 1-Feb-94 M 99 Homer Watson Blvd Kitchener ON N1N 1N1 519-444-1435 4/1/19 15:50 No Headaches 20 Mins Migraine Medication Patient is experiencing migraines on a regular basis $ 1,200.00 4/4/19 18:00
10010 Ken Reid 14341441 1-Mar-01 M 100 River Rd Cambridge ON N1N 1N1 519-545-2435 4/1/19 16:20 Yes Ankle 15 Mins Tylenol 3 Patient injuried Ankle while playing sports $ 1,000.00 4/4/19 18:00
10011 Janet Wilson 124324234 4-Jun-55 F 342 Erb St Waterloo ON N1N 1N1 519-232-8584 4/1/19 16:50 Yes Flu 20 Mins Patient has had the flu for 3 days. Sent home to get rest with Doctor's note $ 1,200.00 4/4/19 18:00
10012 Shannon Terry 63634435 24-Mar-87 F 1004 Weber St N Waterloo ON N1N 1N1 519-145-8954 4/1/19 17:20 Yes Arm 15 Mins Tylenol 3 Patient injured arm while cleaning gutters $ 1,000.00 4/4/19 18:00
10013 Ted Winslow 3432414 6-May-87 M 3484 Conestogo Blvd Waterloo ON N1N 1N1 519-998-7432 4/2/19 9:20 Yes Hands
10014 Cheryl Carter 348230984 20-Apr-00 F 123 Doon Village Rd Kitchener ON N1N 1N1 519-525-1235 4/2/19 9:50 Yes Foot

Sheet2

Sheet3