Consider a “Project Management System” that maintains the database using the following tables:

Consider a “Project Management System” that maintains the database
using the following tables:

Project (p_id, p_title, start_date, duration, end_date, c_id, cost) 
Client (c_id, c_name, c_address, c_phone) 
Employee (e_id, e_name, e_address, e_phone) 
ProjectLeader (p_id,e_id) 

Please note that an employee may be working on morethan one project
in the organization at a time. Write and run the following SQL queries
on the tables:

(a) Find the c_id and c_name of the clients who have given maximum number of projects to the                 company.
(b) Find the list of all the p_id’s, their project details and project leaders of all the projects.
(c) Find the p_id’s whose title starts with “a” or “A”.
(d) Find the projects which will be completed by this month-end.
(e) Find all the clients who have not given any project. Also find the person who is not working on          any project at all.


Note:Make suitable assumptions, if any.