Generate workable queries for old employee data spread across six CSV files by joining and filtering the information to only show the requested information.