sql statement

Return a phone list for patient including patient first name last name

S NoSQL-001-Files > CS150A Test #1 Fall 2018.docx fest #1 Fall 2018.docx 150A Test #1 Fall 2018.docx C27.9 KB) Page SOL SERVER CS 1SOA TEST 1 There are two tables-tblDoctorsGeneralMedicine and tbIDoctorsSpecialtyMedicine whose schema appears as follows. We need a phone list of DoctorName, DoctorSpecialty and DoctorPhone columns for all the doctors, which should be listed only once (no duplicates). Create a query that unites the rows into one set of query result (in other words, a UNION query). 1. tblDoctorsGeneral Medicine Doctoril DoctorName DoctorSpecialtyA [BDO torsSpecialty Medicinal DoctorID DoctorName DoctorPhone DoctorLicense DoctorActive? DoctorLicense DoctorActive? DoctorSpecialty What are the results of the select query as shown below after the create table query is executed 2. CREATE TABLE dbo.Cars(Model varchar 15), Price money, Color varchar 1o INSERT dbo.Cars VALUES 10))% ('sedan', 10000, 'red').('convertible. 7000. blue