Advanced Aggregates Exercise

In this exercise, we will create two different Aggregates, where we’ll need to use multiple sources, calculated attributes, and even aggregation functions. These aggregates will need to respectively answer the following requirements:

  • List all the Employees and the department they belong to. This list of Employees should be sorted alphabetically and present the first and last name of the Employee in the following format: Last Name, First Name.

  • List all the projects in the database. This list should give us all the name of the project, alongside the number of employees in the project, sorted from the project with more members to the one with less members.

You can download a ZIP file of the Exercise Materials by clicking the button below (login required).
It contains all the resources needed for this Lesson, including the Exercise Guide PDF.

Need help with this course? Ask in our Forums. | Have an idea to improve your learning experience? Share in Ideas.