Given The Data Provided Create A Database
Assignment Instructions:
Given the data provided create a database, table in SQL server and answer the following questions:
1.List the patient name and the insurance package name for each patient.
2.List each state and total spent on insurance packages. provide the list in order of the most to least spent.
3. List the hire date, gender and speciality for the doctors that have a ‘blue’ insurance package.
4. List each doctor’s last name, specialty, and the number of insurance packages he/she is currently assigned.
List the patient name, doctor’s first and last name, and the insurance name for each patient.
[wpecpp name=”Buy Now” price=”30″]
