Attached is a query by Adele Tomaino.  Make sure to update the Subnation & SNAME at the end of the query! 


Query updated by Shelley Cooke 1/16/18 to address data model changes.