Write an Structured Query Language (SQL) to list all the details of Parit Raja patients who do not have a phone number. Note that "Parit Raja" may occur anywhere in their address, rather than just at the end.

 

Transcribed Image Text:

PK FK FK HPK Staff StaffID (int) StaffIC(int) StaffName(Varchar) StaffPhone(Varchar) StaffAdd(Varchar) StaffCity (Varchar) StaffStateID(int) HospitalID(int) RoleID(int) PK HPK Role RoleID (int) RoleDescription(Varchar) FK HH State StateID(int) StateName(Varchar) PK FK FK FK HospitalName(Varchar) StateID(int) FK FK FK Hospital HospitalID (int) HP PK CovidResult PatientDiagnosis DiagnosisID (int) PatientID (int) CovidResultID(int) CovidResult(Varchar) ClusterID(int) CaseID(int) PK Close ContactID(int) StatusID (int) StatusDate(Date) CovidResultID(int) CovidResultDate(Date) StaffID(int) FK FK Patient PatientID (int) PatientIC Passport(Varchar) PatientName(Varchar) GuardianName(Varchar) GuardianIC Passport(Varchar) PhoneNo(Varchar) Address(Varchar) City (Varchar) StateID(int) HospitalID(int) HPK HPK PK Status Patient StatusID (int) Status Patient(Varchar) Cluster ClusterID(int) ClusterDescription(Varchar) CaseDetected CaselD(int) Case Description(Varchar) PK FK FK HPK Staff StaffID (int) StaffIC(int) StaffName(Varchar) StaffPhone(Varchar) StaffAdd(Varchar) StaffCity (Varchar) StaffStateID(int) HospitalID(int) RoleID(int) PK HPK Role RoleID (int) RoleDescription(Varchar) FK HH State StateID(int) StateName(Varchar) PK FK FK FK HospitalName(Varchar) StateID(int) FK FK FK Hospital HospitalID (int) HP PK CovidResult PatientDiagnosis DiagnosisID (int) PatientID (int) CovidResultID(int) CovidResult(Varchar) ClusterID(int) CaseID(int) PK Close ContactID(int) StatusID (int) StatusDate(Date) CovidResultID(int) CovidResultDate(Date) StaffID(int) FK FK Patient PatientID (int) PatientIC Passport(Varchar) PatientName(Varchar) GuardianName(Varchar) GuardianIC Passport(Varchar) PhoneNo(Varchar) Address(Varchar) City (Varchar) StateID(int) HospitalID(int) HPK HPK PK Status Patient StatusID (int) Status Patient(Varchar) Cluster ClusterID(int) ClusterDescription(Varchar) CaseDetected CaselD(int) Case Description(Varchar)

Answer rating: 100% (QA)

all the details of Parit Raja patients who do not have a phone number SQL ... View the full answer