Write a query using a minimum of 7 system objects and transform the data into simplified and identifiable formats. System objects should have value in administration of the database. Execute query to insert the results into a table. Comment code appropriately, use proper code formating, and consider the use of truncation, date stamps and indexes if applicable.