Write Cypher queries for the following use cases

1.List all the first name and last name of employees, the project names that they have been working on, and the amount of time they spent for those projects.

2.Get the total number of the projects that each employee has been working on.

 CREATE (d1:Department{ dname:'Headquarters',dnumber:1,mgrssn:'888665555',mgrstartdate:'6/19/1971 12:00:00 AM' }) CREATE (d4:Department{ dname:'Administration',dnumber:4,mgrssn:'987654321',mgrstartdate:'1/1/1985 12:00:00 AM' }) CREATE (d5:Department{ dname:'Research',dnumber:5,mgrssn:'333445555',mgrstartdate:'5/22/1978 12:00:00 AM' }) CREATE (d6:Department{ dname:'Software',dnumber:6,mgrssn:'111111100',mgrstartdate:'5/15/1999 12:00:00 AM' }) CREATE (d7:Department{ dname:'Hardware',dnumber:7,mgrssn:'444444400',mgrstartdate:'5/15/1998 12:00:00 AM' }) CREATE (d8:Department{ dname:'Sales',dnumber:8,mgrssn:'555555500',mgrstartdate:'1/1/1997 12:00:00 AM' }) CREATE (e111111100:Employee{fname:'Jared', minit:'D', lname:'James', ssn:'111111100', bdate: '10/10/1966 12:00:00 AM', address: '123 Peachtree, Atlanta, GA', sex: 'M', salary:85000.00, superssn:'', dno:6}) CREATE (e111111100)-[:WORKS_FOR]->(d6) CREATE (e111111101:Employee{fname:'Jon', minit:'C', lname:'Jones', ssn:'111111101', bdate: '11/14/1967 12:00:00 AM', address: '111 Allgood, Atlanta, GA', sex: 'M', salary:45000.00, superssn:'111111100', dno:6}) CREATE (e111111101)-[:WORKS_FOR]->(d6) CREATE (e111111102:Employee{fname:'Justin', minit:'n', lname:'Mark', ssn:'111111102', bdate: '1/12/1966 12:00:00 AM', address: '2342 May, Atlanta, GA', sex: 'M', salary:40000.00, superssn:'111111100', dno:6}) CREATE (e111111102)-[:WORKS_FOR]->(d6) CREATE (e111111103:Employee{fname:'Brad', minit:'C', lname:'Knight', ssn:'111111103', bdate: '2/13/1968 12:00:00 AM', address: '176 Main St., Atlanta, GA', sex: 'M', salary:44000.00, superssn:'111111100', dno:6}) CREATE (e111111103)-[:WORKS_FOR]->(d6) CREATE (e123456789:Employee{fname:'John', minit:'B', lname:'Smith', ssn:'123456789', bdate: '1/9/1955 12:00:00 AM', address: '731 Fondren, Houston, TX', sex: 'M', salary:30000.00, superssn:'333445555', dno:5}) CREATE (e123456789)-[:WORKS_FOR]->(d5) CREATE (e222222200:Employee{fname:'Evan', minit:'E', lname:'Wallis', ssn:'222222200', bdate: '1/16/1958 12:00:00 AM', address: '134 Pelham, Milwaukee, WI', sex: 'M', salary:92000.00, superssn:'', dno:7}) CREATE (e222222200)-[:WORKS_FOR]->(d7) CREATE (e222222201:Employee{fname:'Josh', minit:'U', lname:'Zell', ssn:'222222201', bdate: '5/22/1954 12:00:00 AM', address: '266 McGrady, Milwaukee, WI', sex: 'M', salary:56000.00, superssn:'222222200', dno:7}) CREATE (e222222201)-[:WORKS_FOR]->(d7) CREATE (e222222202:Employee{fname:'Andy', minit:'C', lname:'Vile', ssn:'222222202', bdate: '6/21/1944 12:00:00 AM', address: '1967 Jordan, Milwaukee, WI', sex: 'M', salary:53000.00, superssn:'222222200', dno:7}) CREATE (e222222202)-[:WORKS_FOR]->(d7) CREATE (e222222203:Employee{fname:'Tom', minit:'G', lname:'Brand', ssn:'222222203', bdate: '12/16/1966 12:00:00 AM', address: '112 Third St, Milwaukee, WI', sex: 'M', salary:62500.00, superssn:'222222200', dno:7}) CREATE (e222222203)-[:WORKS_FOR]->(d7) CREATE (e222222204:Employee{fname:'Jenny', minit:'F', lname:'Vos', ssn:'222222204', bdate: '11/11/1967 12:00:00 AM', address: '263 Mayberry, Milwaukee, WI', sex: 'F', salary:61000.00, superssn:'222222201', dno:7}) CREATE (e222222204)-[:WORKS_FOR]->(d7) CREATE (e222222205:Employee{fname:'Chris', minit:'A', lname:'Carter', ssn:'222222205', bdate: '3/21/1960 12:00:00 AM', address: '565 Jordan, Milwaukee, WI', sex: 'F', salary:43000.00, superssn:'222222201', dno:7}) CREATE (e222222205)-[:WORKS_FOR]->(d7) CREATE (e333333300:Employee{fname:'Kim', minit:'C', lname:'Grace', ssn:'333333300', bdate: '10/23/1970 12:00:00 AM', address: '6677 Mills Ave, Sacramento, CA', sex: 'F', salary:79000.00, superssn:'', dno:6}) CREATE (e333333300)-[:WORKS_FOR]->(d6) CREATE (e333333301:Employee{fname:'Jeff', minit:'H', lname:'Chase', ssn:'333333301', bdate: '1/7/1970 12:00:00 AM', address: '145 Bradbury, Sacramento, CA', sex: 'M', salary:44000.00, superssn:'333333300', dno:6}) CREATE (e333333301)-[:WORKS_FOR]->(d6) CREATE (e333445555:Employee{fname:'Franklin', minit:'T', lname:'Wong', ssn:'333445555', bdate: '12/8/1945 12:00:00 AM', address: '638 Voss, Houston, TX', sex: 'M', salary:40000.00, superssn:'888665555', dno:5}) CREATE (e333445555)-[:WORKS_FOR]->(d5) CREATE (e444444400:Employee{fname:'Alex', minit:'D', lname:'Freed', ssn:'444444400', bdate: '10/9/1950 12:00:00 AM', address: '4333 Pillsbury, Milwaukee, WI', sex: 'M', salary:89000.00, superssn:'null', dno:7}) CREATE (e444444400)-[:WORKS_FOR]->(d7) CREATE (e444444401:Employee{fname:'Bonnie', minit:'S', lname:'Bays', ssn:'444444401', bdate: '6/19/1956 12:00:00 AM', address: '111 Hollow, Milwaukee, WI', sex: 'F', salary:70000.00, superssn:'444444400', dno:7}) CREATE (e444444401)-[:WORKS_FOR]->(d7) CREATE (e444444402:Employee{fname:'Alec', minit:'C', lname:'Best', ssn:'444444402', bdate: '6/18/1966 12:00:00 AM', address: '233 Solid, Milwaukee, WI', sex: 'M', salary:60000.00, superssn:'444444400', dno:7}) CREATE (e444444402)-[:WORKS_FOR]->(d7) CREATE (e444444403:Employee{fname:'Sam', minit:'S', lname:'Snedden', ssn:'444444403', bdate: '7/31/1977 12:00:00 AM', address: '987 Windy St, Milwaukee, WI', sex: 'M', salary:48000.00, superssn:'444444400', dno:7}) CREATE (e444444403)-[:WORKS_FOR]->(d7) CREATE (e453453453:Employee{fname:'Joyce', minit:'A', lname:'English', ssn:'453453453', bdate: '7/31/1962 12:00:00 AM', address: '5631 Rice, Houston, TX', sex: 'F', salary:25000.00, superssn:'333445555', dno:5}) CREATE (e453453453)-[:WORKS_FOR]->(d5) CREATE (e555555500:Employee{fname:'John', minit:'C', lname:'James', ssn:'555555500', bdate: '6/30/1975 12:00:00 AM', address: '7676 Bloomington, Sacramento, CA', sex: 'M', salary:81000.00, superssn:'null', dno:6}) CREATE (e555555500)-[:WORKS_FOR]->(d6) CREATE (e555555501:Employee{fname:'Nandita', minit:'K', lname:'Ball', ssn:'555555501', bdate: '4/16/1969 12:00:00 AM', address: '222 Howard, Sacramento, CA', sex: 'M', salary:62000.00, superssn:'555555500', dno:6}) CREATE (e555555501)-[:WORKS_FOR]->(d6) CREATE (e666666600:Employee{fname:'Bob', minit:'B', lname:'Bender', ssn:'666666600', bdate: '4/17/1968 12:00:00 AM', address: '8794 Garfield, Chicago, IL', sex: 'M', salary:96000.00, superssn:'null', dno:8}) CREATE (e666666600)-[:WORKS_FOR]->(d8) CREATE (e666666601:Employee{fname:'Jill', minit:'J', lname:'Jarvis', ssn:'666666601', bdate: '1/14/1966 12:00:00 AM', address: '6234 Lincoln, Chicago, IL', sex: 'F', salary:36000.00, superssn:'666666600', dno:8}) CREATE (e666666601)-[:WORKS_FOR]->(d8) CREATE (e666666602:Employee{fname:'Kate', minit:'W', lname:'King', ssn:'666666602', bdate: '4/16/1966 12:00:00 AM', address: '1976 Boone Trace, Chicago, IL', sex: 'F', salary:44000.00, superssn:'666666600', dno:8}) CREATE (e666666602)-[:WORKS_FOR]->(d8) CREATE (e666666603:Employee{fname:'Lyle', minit:'G', lname:'Leslie', ssn:'666666603', bdate: '6/9/1963 12:00:00 AM', address: '417 Hancock Ave, Chicago, IL', sex: 'M', salary:41000.00, superssn:'666666601', dno:8}) CREATE (e666666603)-[:WORKS_FOR]->(d8) CREATE (e666666604:Employee{fname:'Billie', minit:'J', lname:'King', ssn:'666666604', bdate: '1/1/1960 12:00:00 AM', address: '556 Washington, Chicago, IL', sex: 'F', salary:38000.00, superssn:'666666603', dno:8}) CREATE (e666666604)-[:WORKS_FOR]->(d8) CREATE (e666666605:Employee{fname:'Jon', minit:'A', lname:'Kramer', ssn:'666666605', bdate: '8/22/1964 12:00:00 AM', address: '1988 Windy Creek, Seattle, WA', sex: 'M', salary:41500.00, superssn:'666666603', dno:8}) CREATE (e666666605)-[:WORKS_FOR]->(d8) CREATE (e666666606:Employee{fname:'Ray', minit:'H', lname:'King', ssn:'666666606', bdate: '8/16/1949 12:00:00 AM', address: '213 Delk Road, Seattle, WA', sex: 'M', salary:44500.00, superssn:'666666604', dno:8}) CREATE (e666666606)-[:WORKS_FOR]->(d8) CREATE (e666666607:Employee{fname:'Gerald', minit:'D', lname:'Small', ssn:'666666607', bdate: '5/15/1962 12:00:00 AM', address: '122 Ball Street, Dallas, TX', sex: 'M', salary:29000.00, superssn:'666666602', dno:8}) CREATE (e666666607)-[:WORKS_FOR]->(d8) CREATE (e666666608:Employee{fname:'Arnold', minit:'A', lname:'Head', ssn:'666666608', bdate: '5/19/1967 12:00:00 AM', address: '233 Spring St, Dallas, TX', sex: 'M', salary:33000.00, superssn:'666666602', dno:8}) CREATE (e666666608)-[:WORKS_FOR]->(d8) CREATE (e666666609:Employee{fname:'Helga', minit:'C', lname:'Pataki', ssn:'666666609', bdate: '3/11/1969 12:00:00 AM', address: '101 Holyoke St, Dallas, TX', sex: 'F', salary:32000.00, superssn:'666666602', dno:8}) CREATE (e666666609)-[:WORKS_FOR]->(d8) CREATE (e666666610:Employee{fname:'Naveen', minit:'B', lname:'Drew', ssn:'666666610', bdate: '5/23/1970 12:00:00 AM', address: '198 Elm St, Philadelphia, PA', sex: 'M', salary:34000.00, superssn:'666666607', dno:8}) CREATE (e666666610)-[:WORKS_FOR]->(d8) CREATE (e666666611:Employee{fname:'Carl', minit:'E', lname:'Reedy', ssn:'666666611', bdate: '6/21/1977 12:00:00 AM', address: '213 Ball St, Philadelphia, PA', sex: 'M', salary:32000.00, superssn:'666666610', dno:8}) CREATE (e666666611)-[:WORKS_FOR]->(d8) CREATE (e666666612:Employee{fname:'Sammy', minit:'G', lname:'Hall', ssn:'666666612', bdate: '1/11/1970 12:00:00 AM', address: '433 Main Street, Miami, FL', sex: 'M', salary:37000.00, superssn:'666666611', dno:8}) CREATE (e666666612)-[:WORKS_FOR]->(d8) CREATE (e666666613:Employee{fname:'Red', minit:'A', lname:'Bacher', ssn:'666666613', bdate: '5/21/1980 12:00:00 AM', address: '196 Elm Street, Miami, FL', sex: 'M', salary:33500.00, superssn:'666666612', dno:8}) CREATE (e666666613)-[:WORKS_FOR]->(d8) CREATE (e666884444:Employee{fname:'Ramesh', minit:'K', lname:'Narayan', ssn:'666884444', bdate: '9/15/1952 12:00:00 AM', address: '971 Fire Oak, Humble, TX', sex: 'M', salary:38000.00, superssn:'333445555', dno:5}) CREATE (e666884444)-[:WORKS_FOR]->(d5) CREATE (e888665555:Employee{fname:'James', minit:'E', lname:'Borg', ssn:'888665555', bdate: '11/10/1927 12:00:00 AM', address: '450 Stone, Houston, TX', sex: 'M', salary:55000.00, superssn:'null', dno:1}) CREATE (e888665555)-[:WORKS_FOR]->(d1) CREATE (e987654321:Employee{fname:'Jennifer', minit:'S', lname:'Wallace', ssn:'987654321', bdate: '6/20/1931 12:00:00 AM', address: '291 Berry, Bellaire, TX', sex: 'F', salary:43000.00, superssn:'888665555', dno:4}) CREATE (e987654321)-[:WORKS_FOR]->(d4) CREATE (e987987987:Employee{fname:'Ahmad', minit:'V', lname:'Jabbar', ssn:'987987987', bdate: '3/29/1959 12:00:00 AM', address: '980 Dallas, Houston, TX', sex: 'M', salary:25000.00, superssn:'987654321', dno:4}) CREATE (e987987987)-[:WORKS_FOR]->(d4) CREATE (e999887777:Employee{fname:'Alicia', minit:'J', lname:'Zelaya', ssn:'999887777', bdate: '7/19/1958 12:00:00 AM', address: '3321 Castle, Spring, TX', sex: 'F', salary:25000.00, superssn:'987654321', dno:4}) CREATE (e999887777)-[:WORKS_FOR]->(d4) CREATE (locHouston:Location{dlocation:'Houston'}) CREATE (locStafford:Location{dlocation:'Stafford'}) CREATE (locBellaire:Location{dlocation:'Bellaire'}) CREATE (locSugarland:Location{dlocation:'Sugarland'}) CREATE (locAtlanta:Location{dlocation:'Atlanta'}) CREATE (locSacramento:Location{dlocation:'Sacramento'}) CREATE (locMilwaukee:Location{dlocation:'Milwaukee'}) CREATE (locChicago:Location{dlocation:'Chicago'}) CREATE (locDallas:Location{dlocation:'Dallas'}) CREATE (locMiami:Location{dlocation:'Miami'}) CREATE (locPhiladephia:Location{dlocation:'Philadephia'}) CREATE (locSeattle:Location{dlocation:'Seattle'}) CREATE (d1)-[:LOCATED_IN]->(locHouston) CREATE (d4)-[:LOCATED_IN]->(locStafford) CREATE (d5)-[:LOCATED_IN]->(locBellaire) CREATE (d5)-[:LOCATED_IN]->(locHouston) CREATE (d5)-[:LOCATED_IN]->(locSugarland) CREATE (d6)-[:LOCATED_IN]->(locAtlanta) CREATE (d6)-[:LOCATED_IN]->(locSacramento) CREATE (d7)-[:LOCATED_IN]->(locMilwaukee) CREATE (d8)-[:LOCATED_IN]->(locChicago) CREATE (d8)-[:LOCATED_IN]->(locDallas) CREATE (d8)-[:LOCATED_IN]->(locMiami) CREATE (d8)-[:LOCATED_IN]->(locPhiladephia) CREATE (d8)-[:LOCATED_IN]->(locSeattle) CREATE (p1:Project{ pname:'ProductX', pnumber:1, plocation:'Bellaire', dnum:5 }) CREATE (p2:Project{ pname:'ProductY', pnumber:2, plocation:'Sugarland', dnum:5 }) CREATE (p3:Project{ pname:'ProductZ', pnumber:3, plocation:'Houston', dnum:5 }) CREATE (p10:Project{ pname:'Computerization', pnumber:10, plocation:'Stafford', dnum:4 }) CREATE (p20:Project{ pname:'Reorganization', pnumber:20, plocation:'Houston', dnum:1 }) CREATE (p30:Project{ pname:'Newbenefits', pnumber:30, plocation:'Stafford', dnum:4 }) CREATE (p61:Project{ pname:'OperatingSystems', pnumber:61, plocation:'Jacksonville', dnum:6 }) CREATE (p62:Project{ pname:'DatabaseSystems', pnumber:62, plocation:'Birmingham', dnum:6 }) CREATE (p63:Project{ pname:'Middleware', pnumber:63, plocation:'Jackson', dnum:6 }) CREATE (p91:Project{ pname:'InkjetPrinters', pnumber:91, plocation:'Phoenix', dnum:7 }) CREATE (p92:Project{ pname:'LaserPrinters', pnumber:92, plocation:'LasVegas', dnum:7 }) CREATE (e111111100)-[:WORKS_ON{hours:40.0}]->(p61) CREATE (e111111101)-[:WORKS_ON{hours:40.0}]->(p61) CREATE (e111111102)-[:WORKS_ON{hours:40.0}]->(p61) CREATE (e111111103)-[:WORKS_ON{hours:40.0}]->(p61) CREATE (e123456789)-[:WORKS_ON{hours:32.5}]->(p1) CREATE (e123456789)-[:WORKS_ON{hours:7.5}]->(p2) CREATE (e222222200)-[:WORKS_ON{hours:40.0}]->(p62) CREATE (e222222201)-[:WORKS_ON{hours:48.0}]->(p62) CREATE (e222222202)-[:WORKS_ON{hours:40.0}]->(p62) CREATE (e222222203)-[:WORKS_ON{hours:40.0}]->(p62) CREATE (e222222204)-[:WORKS_ON{hours:40.0}]->(p62) CREATE (e222222205)-[:WORKS_ON{hours:40.0}]->(p62) CREATE (e333333300)-[:WORKS_ON{hours:40.0}]->(p63) CREATE (e333333301)-[:WORKS_ON{hours:46.0}]->(p63) CREATE (e333445555)-[:WORKS_ON{hours:10.0}]->(p2) CREATE (e333445555)-[:WORKS_ON{hours:10.0}]->(p3) CREATE (e333445555)-[:WORKS_ON{hours:10.0}]->(p10) CREATE (e333445555)-[:WORKS_ON{hours:10.0}]->(p20) CREATE (e444444400)-[:WORKS_ON{hours:40.0}]->(p91) CREATE (e444444401)-[:WORKS_ON{hours:40.0}]->(p91) CREATE (e444444402)-[:WORKS_ON{hours:40.0}]->(p91) CREATE (e444444403)-[:WORKS_ON{hours:40.0}]->(p91) CREATE (e453453453)-[:WORKS_ON{hours:20.0}]->(p1) CREATE (e453453453)-[:WORKS_ON{hours:20.0}]->(p2) CREATE (e555555500)-[:WORKS_ON{hours:40.0}]->(p92) CREATE (e555555501)-[:WORKS_ON{hours:44.0}]->(p92) CREATE (e666666601)-[:WORKS_ON{hours:40.0}]->(p91) CREATE (e666666603)-[:WORKS_ON{hours:40.0}]->(p91) CREATE (e666666604)-[:WORKS_ON{hours:40.0}]->(p91) CREATE (e666666605)-[:WORKS_ON{hours:40.0}]->(p92) CREATE (e666666606)-[:WORKS_ON{hours:40.0}]->(p91) CREATE (e666666607)-[:WORKS_ON{hours:40.0}]->(p61) CREATE (e666666608)-[:WORKS_ON{hours:40.0}]->(p62) CREATE (e666666609)-[:WORKS_ON{hours:40.0}]->(p63) CREATE (e666666610)-[:WORKS_ON{hours:40.0}]->(p61) CREATE (e666666611)-[:WORKS_ON{hours:40.0}]->(p61) CREATE (e666666612)-[:WORKS_ON{hours:40.0}]->(p61) CREATE (e666666613)-[:WORKS_ON{hours:30.0}]->(p61) CREATE (e666666613)-[:WORKS_ON{hours:10.0}]->(p62) CREATE (e666666613)-[:WORKS_ON{hours:10.0}]->(p63) CREATE (e666884444)-[:WORKS_ON{hours:40.0}]->(p3) CREATE (e888665555)-[:WORKS_ON{hours:0.0}]->(p20) CREATE (e987654321)-[:WORKS_ON{hours:15.0}]->(p20) CREATE (e987654321)-[:WORKS_ON{hours:20.0}]->(p30) CREATE (e987987987)-[:WORKS_ON{hours:35.0}]->(p10) CREATE (e987987987)-[:WORKS_ON{hours:5.0}]->(p30) CREATE (e999887777)-[:WORKS_ON{hours:10.0}]->(p10) CREATE (e999887777)-[:WORKS_ON{hours:30.0}]->(p30) CREATE (dep1:Dependent{essn:123456789,dependent_name:'Alice', sex:'F', bdate:'12/31/1978 12:00:00 AM', relationship:'Daughter' }) CREATE (e123456789)-[:DEPENDENT_OF]->(dep1) CREATE (dep2:Dependent{essn:123456789,dependent_name:'Elizabeth', sex:'F', bdate:'9/15/1977 12:00:00 AM', relationship:'Spouse' }) CREATE (e123456789)-[:DEPENDENT_OF]->(dep2) CREATE (dep3:Dependent{essn:123456789,dependent_name:'John', sex:'M', bdate:'1/1/1978 12:00:00 AM', relationship:'Son' }) CREATE (e123456789)-[:DEPENDENT_OF]->(dep3) CREATE (dep4:Dependent{essn:333445555,dependent_name:'Alice', sex:'F', bdate:'4/5/1976 12:00:00 AM', relationship:'Daughter' }) CREATE (e333445555)-[:DEPENDENT_OF]->(dep4) CREATE (dep5:Dependent{essn:333445555,dependent_name:'Franklin', sex:'M', bdate:'10/25/1973 12:00:00 AM', relationship:'Son' }) CREATE (e333445555)-[:DEPENDENT_OF]->(dep5) CREATE (dep6:Dependent{essn:333445555,dependent_name:'Joy', sex:'F', bdate:'5/3/1948 12:00:00 AM', relationship:'Spouse' }) CREATE (e333445555)-[:DEPENDENT_OF]->(dep6) CREATE (dep7:Dependent{essn:444444400,dependent_name:'Johnny', sex:'M', bdate:'4/4/1997 12:00:00 AM', relationship:'Son' }) CREATE (e444444400)-[:DEPENDENT_OF]->(dep7) CREATE (dep8:Dependent{essn:444444400,dependent_name:'Tommy', sex:'M', bdate:'6/7/1999 12:00:00 AM', relationship:'Son' }) CREATE (e444444400)-[:DEPENDENT_OF]->(dep8) CREATE (dep9:Dependent{essn:444444401,dependent_name:'Chris', sex:'M', bdate:'4/19/1969 12:00:00 AM', relationship:'Spouse' }) CREATE (e444444401)-[:DEPENDENT_OF]->(dep9) CREATE (dep10:Dependent{essn:444444402,dependent_name:'Sam', sex:'M', bdate:'2/14/1964 12:00:00 AM', relationship:'Spouse' }) CREATE (e444444402)-[:DEPENDENT_OF]->(dep10) CREATE (dep11:Dependent{essn:987654321,dependent_name:'Abner', sex:'M', bdate:'2/29/1932 12:00:00 AM', relationship:'Spouse' }) CREATE (e987654321)-[:DEPENDENT_OF]->(dep11)