In this phase you will demonstrate your knowledge of selecting data from single tables.$$ You will need to use techniques such as concatenation, sorting, and different uses of the where clause to return the data.$$

You will create one $.$sql file that contains all the Select statements and submit it to Blackboard for grading.$$ Any statement that indicates full name means to concatenate the first and last name.$$ Use aliases where needed.

There are ten $(10)$ Select statements that you will write.$$ Each is worth $15$ points.$$ To receive full credit your statement must be syntactically correct and must return the correct results.$$ Please be sure that your statements are in the order listed below.$$ I have included screenshots of the results so you can check your SQL and fix as needed $4.$ Write the select statement that will return the full name of all employees who are physicians or surgeons. Sort on last name within type.

$5.$ Write the select statement that will return a list of medical conditions sorted on the description.

$6.$ Write the select statement that will return a list of prescriptions that have a dosage of $20$ mg $.$ Sort on the ID$.7.$ Write the select statement that will return the full name and date of hire for all employees hired on or after January $1,2019.$ Sort on date of hire from newest date of hire first.

$8.$ Write the select statement that will return a list of all female employees sorted on last name.

$9.$ Write the select statement that will return a list of specialties involving surgery.

$10.$ Write the select statement that will return the full name, city and state of all male patients who do not live in MA$.$