PROJECT 2 points. Write a roster report for the entire region.

There are two things in the roster from NMRA that the Region leadership does NOT like. They do not like the impersonal division numbers, and prefer to use the title of the division. There is also a member type in the roster which is just a two or three letter code. They would rather know what that member type really means. You have been supplied with a list of all 16 divisions and their superintendents and division names, along with a listing of the member type codes and their meaning and also a rollup we will use in the future for counting members by.

Write a script for a roster of the entire region. Note that we are not using the division number or the member type abbreviation, we are looking the full nomenclature for division name and member type and including them in the report. As usual, review your report for any missing information and correct any problems. Ask the customer (me) for resolution if needed.

ID

Name, similar to the report from Module 4

Full Mailing address, similar to the report from Module 4

Join Date

Expiration Date

Division name (from the division table)

Member type (Meaning column from the member type table).

Note you are going to need to refer to your EER and/or check the tables in order to execute the JOIN commands to the correct columns between the tables.

Provide two reports based upon the following sorts:

Sorted by Division, then last name

Sorted by Division then member type.

What to Submit:

CSV Exports of each report per instructions in Module 3.

The SQL scripts used for each report