Write a SQL query to get the doctor_name where the city they live in is not the same as the city their hospital is in
Table Name: Doctor
doctor_id
doctor_name
lives_in_city
specialization
hospital_id
3001
Dr. John Smith
New York
Cardiology
2001
3002
Dr. Emily Davis
Chicago
Neurology
2002
3003
Dr. Sarah Lee
Los Angeles
Pediatrics
2003
3004
Dr. Mark Brown
Miami
Oncology
2004
3005
Dr. Anna White
San Diego
Orthopedics
2005
3006
Dr. David Clark
Houston
General Surgery
2006
3007Dr. Hanna HostMiamiRadiologist2005
table Name: Hospital
hospital_id
name
city
patients_admitted
patients_discharged
2001
City Hospital
New York
150
120
2002
Green Valley Clinic
Chicago
200
180
2003
Sunshine Medical Center
Los Angeles
100
90
2004
Lakeside Health Facility
Miami
300
250
2005
Hilltop General Hospital
San Diego
400
350
2006
Oceanview Medical Center
Houston
250
220
Important - Read this before proceeding
These instructions reflect a task our writers previously completed for another student. Should you require assistance with the same assignment, please submit your homework details to our writers’ platform. This will ensure you receive an original paper, you can submit as your own. For further guidance, visit our ‘How It Works’ page.