Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.

PK FK FK HPK Staff StaffID (int) StaffIC(int) StaffName(Varchar) StaffPhone(Varchar) StaffAdd(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)

Step by Step Solution

3.41 Rating (157 Votes )

There are 3 Steps involved in it

Step: 1

all the details of Parit Raja patients who do not have a phone number SQL ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students also viewed these Databases questions