Lab: Material Popularity Report

The first objective of this lab assignment is to produce a material popularity report. The second objective is to produce a material type popularity report.

Definitions:

• Material popularity measure: The number of jobs in which a certain material has been used.
• Material type popularity measure: The number of jobs in which a material of a certain type has been used.

1.

Produce a report, called Material Popularity Report, showing each material, along with its popularity. Sort on material popularity, in ascending order. Make sure the definition of how material popularity is measured is explicitly stated in the report.

Deliverable: A screen shot of the report

2.

Produce a report, called Material Type Popularity Report, showing each material type, along with its popularity. Sort on material type popularity, in ascending order. Make sure the definition of how material type popularity is measured is explicitly stated in the report.

Deliverable: A screen shot of the report