Sorting, Grouping, and Nesting Data

In this assignment, you will use SQL DML statements that aggregate, sort, and nest data about employees and departments of a company.
You will use the Employee and Department tables you created previously. Create, run, and test SQL queries to display each set of information. Save a copy of your queries in a Microsoft Word document.

Include a screen shot to verify the successful completion of each SQL command.  Each Screen shot must be preceded by a comment that includes the student’s name, the instructor’s name, and the date the command was executed.

E.g.  SQL>/* Student: John Doe  Instructor: Sally Smith  Date: 4/4/2021 */

Note:  Don’t forget the /* and */ at the start and end of the command to make it into a comment!!

The screen shot must include the SQL command and the output from the command. Include one screen shot per item.  The screen shots must be well formatted and the output easily readable.  Points may be subtracted from the total score for poor presentation of the assignment material.

See examples below: