I just need the queries written for part 3. Part one has all the table names listed. I have attached the instructions, and the excel file containing the data
The only catch is with the way my data is pulled into i have to use the “temp” table to pull data.. as the example in #1 shows:
select Lastname + ‘, ‘ + FirstName as PatientName
from Patients
where lastname like ‘P%’
order by lastname
mine is :
select Lastname + ‘, ‘ + FirstName as PatientName
from TempPatients
where lastname like ‘P%’
order by lastname