Hello. I have gone through the schema shared by you. Assuming that the Managers ID is present in the Employee Table, we will need to work around the "employee" and the "employee_projects" tables. I can write this query for you and if you have even more complex queries, i can do them for us, as i not only have a lot of experience in SQL, but i have developed a number of HR Systems, so i have the technical and business knowledge as well.
As an SQL Developer, i have developed optimized database objects (including Views, Stored Procedures, functions, etc) for numerous systems.
I have expertise optimizing databases, queries and stored procedures, with hands on experience on huge transactional systems.
I also have experience analyzing, cleaning and importing data.
I have loads of experience in extracting meaning ful information from huge chunks of raw data, based on required criteria.
I can start right away. I am looking for a long-term relationship based on Quality of Work, Professionalism and Honesty.
Kindly have a look at my resume for better understanding of my skills and experience:
http://technologyjunction.com.pk/downloads/Screenshots/HaroonMushtaq-Resume-PM&SolutionArchitect).pdf
Looking forward to hear from you.
Have a good day!