i need sql server like that , help me to answer this

Jestion 2: (2 pts) (chapter 3) . Drew the ER diagram of this problem: A patient has the data : idPatient, namePatient, mobile. A doctor has the data : idDoctor, nameDoctor, officeNumber, specialty. A doctor treats one or many patients. A patient is treated by one doctor. There are only 2 types of patients: resident and out-patient. . Patient id Patient namePatient mobile doctor id Doctor name Doctor office Number I specialty out-Patient resident