The new scheduling manager has asked for a summary of hours worked each week by

Question

The new scheduling manager has asked for a summary of hours worked each week by department. Accounting for NULL values, use the imported sheet again for "Hours" to SUM by department title for all employees on the table

Last Name First Name Job title Row Labels Staff Sánchez Ken Chief Executive Officer Accountant 2 Duffy Terri Vice President of Engineering Accounts Manager 1 Tamburello Roberto Engineering Manager Accounts Payable Specialist 2 Walters Rob Senior Tool Designer Accounts Receivable Specialist 3 Erickson Gail Design Engineer Application Specialist 4 Goldberg Jossef Design Engineer Assistant to the Chief Financial Officer 1 Miller Dylan Research and Development Manager Benefits Specialist 1 Margheim Diane Research and Development Engineer Buyer 9 Matthew Gigi Research and Development Engineer Chief Executive Officer 1 Raheem Michael Research and Development Manager Chief Financial Officer 1 Cracium Ovidiu Senior Tool Designer Control Specialist 2 D'Hers Thierry Tool Designer Database Administrator 2 Galvin Janice Tool Designer Design Engineer 3 Sullivan Michael Senior Design Engineer Document Control Assistant 2 Salavaria Sharon Design Engineer Document Control Manager 1 Bradley David Marketing Manager Engineering Manager 1 Brown Kevin Marketing Assistant European Sales Manager 1 Wood John Marketing Specialist Facilities Administrative Assistant 1 Dempsey Mary Marketing Assistant Facilities Manager 1 Benshoof Wanida Marketing Assistant Finance Manager 1 Eminhizer Terry Marketing Specialist Human Resources Administrative Assistant 2 Harnpadoungsataya Sariya Marketing Specialist Human Resources Manager 1 Gibson Mary Marketing Specialist Information Services Manager 1 Williams Jill Marketing Specialist Janitor 4 Hamilton James Vice President of Production Maintenance Supervisor 1 Krebs Peter Production Control Manager Marketing Assistant 3 Brown Jo Production Supervisor - WC60 Marketing Manager 1 Gilbert Guy Production Technician - WC60 Marketing Specialist 5 McArthur Mark Production Technician - WC60 Master Scheduler 1 Simon Britta Production Technician - WC60 Network Administrator 2 Shoop Margie Production Technician - WC60 Network Manager 1 Laszlo Rebecca Production Technician - WC60 North American Sales Manager 1 Stahl Annik Production Technician - WC60 Pacific Sales Manager 1 Mohan Suchitra Production Technician - WC60 Production Control Manager 1 Heidepriem Brandon Production Technician - WC60 Production Supervisor - WC10 3 Lugo Jose Production Technician - WC60 Production Supervisor - WC20 3 Okelberry Chris Production Technician - WC60 Production Supervisor - WC30 3 Abercrombie Kim Production Technician - WC60 Production Supervisor - WC40 3 Dudenhoefer Ed Production Technician - WC60 Production Supervisor - WC45 3 Dobney JoLynn Production Supervisor - WC60 Production Supervisor - WC50 3 Baker Bryan Production Technician - WC60 Production Supervisor - WC60 3 Kramer James Production Technician - WC60 Production Technician - WC10 17 Anderson Nancy Production Technician - WC60 Production Technician - WC20 22 Rapier Simon Production Technician - WC60 Production Technician - WC30 25 Michaels Thomas Production Technician - WC60 Production Technician - WC40 26 Kogan Eugene Production Technician - WC60 Production Technician - WC45 15 Hill Andrew Production Supervisor - WC10 Production Technician - WC50 26 Ellerbrock Ruth Production Technician - WC10 Production Technician - WC60 26 Johnson Barry Production Technician - WC10 Purchasing Assistant 2 Higa Sidney Production Technician - WC10 Purchasing Manager 1 Ford Jeffrey Production Technician - WC10 Quality Assurance Manager 1 Hartwig Doris Production Technician - WC10 Quality Assurance Supervisor 1 Glimp Diane Production Technician - WC10 Quality Assurance Technician 4 Kearney Bonnie Production Technician - WC10 Recruiter 2 Maxwell Taylor Production Supervisor - WC50 Research and Development Engineer 2 Smith Denise Production Technician - WC50 Research and Development Manager 2 Miller Frank Production Technician - WC50 Sales Representative 14 Keil Kendall Production Technician - WC50 Scheduling Assistant 4 Hohman Bob Production Technician - WC50 Senior Design Engineer 1 Male Pete Production Technician - WC50 Senior Tool Designer 2 Tibbott Diane Production Technician - WC50 Shipping and Receiving Clerk 2 Campbell John Production Supervisor - WC60 Shipping and Receiving Supervisor 1 Dusza Maciej Production Technician - WC60 Stocker 3 Zwilling Michael Production Technician - WC60 Tool Designer 2 Reeves Randy Production Technician - WC60 Vice President of Engineering 1 Khanna Karan Production Technician - WC60 Vice President of Production 1 Adams Jay Production Technician - WC60 Vice President of Sales 1 Fitzgerald Charles Production Technician - WC60 (blank) Masters Steve Production Technician - WC60 Grand Total 290 Ortiz David Production Technician - WC60 Ray Michael Production Supervisor - WC30 Selikoff Steven Production Technician - WC30 Poland Carole Production Technician - WC30 Rettig Bjorn Production Technician - WC30 Osada Michiko Production Technician - WC30 Philips Carol Production Technician - WC30 Netz Merav Production Technician - WC30 D'sa Reuben Production Supervisor - WC40 Brown Eric Production Technician - WC40 Kaliyath Sandeep Production Technician - WC40 Frintu Mihail Production Technician - WC40 Creasey Jack Production Technician - WC40 Cook Patrick Production Technician - WC40 Martinez Frank Production Technician - WC40 Goldstein Brian Production Technician - WC40 Cornelsen Ryan Production Technician - WC40 Petculescu Cristian Production Supervisor - WC10 Stadick Betsy Production Technician - WC10 Wedge Patrick Production Technician - WC10 Tiedt Danielle Production Technician - WC10 Zimmerman Kimberly Production Technician - WC10 Vande Velde Tom Production Technician - WC10 Loh Kok-Ho Production Supervisor - WC50 Hunter Russell Production Technician - WC50 Scardelis Jim Production Technician - WC50 Keyser Elizabeth Production Technician - WC50 Samant Mandar Production Technician - WC50 Tejani Sameer Production Technician - WC50 Yu Nuan Production Technician - WC50 Song Lolan Production Technician - WC50 Pournasseh Houman Production Technician - WC50 Mu Zheng Production Supervisor - WC10 Ersan Ebru Production Technician - WC10 Baker Mary Production Technician - WC10 Homer Kevin Production Technician - WC10 Kane John Production Technician - WC10 Hill Christopher Production Technician - WC10 Liu Jinghao Production Supervisor - WC50 Ciccu Alice Production Technician - WC50 Cao Jun Production Technician - WC50 Fatima Suroor Production Technician - WC50 Evans John Production Technician - WC50 Moschell Linda Production Technician - WC50 Krapauskas Mindaugas Production Technician - WC50 Barbariol Angela Production Technician - WC50 Patten Michael Production Technician - WC50 Niswonger Chad Production Technician - WC50 Hall Don Production Technician - WC50 Entin Michael Production Technician - WC50 Lertpiriyasuwat Kitti Production Technician - WC50 Ackerman Pilar Shipping and Receiving Supervisor Eaton Susan Stocker Kuppa Vamsi Shipping and Receiving Clerk Ralls Kim Stocker Berndt Matthias Shipping and Receiving Clerk Bischoff Jimmy Stocker Hamilton David Production Supervisor - WC40 Komosinski Paul Production Technician - WC40 Yukish Gary Production Technician - WC40 Caron Rob Production Technician - WC40 Cetinok Baris Production Technician - WC40 Holliday Nicole Production Technician - WC40 Rothkugel Michael Production Technician - WC40 Gubbels Eric Production Supervisor - WC20 Salmre Ivo Production Technician - WC20 Valdez Sylvester Production Technician - WC20 Sousa Anibal Production Technician - WC20 Smith Samantha Production Technician - WC20 Ting Hung-Fu Production Technician - WC20 Samarawickrama Prasanna Production Technician - WC20 Su Min Production Technician - WC20 Turner Olinda Production Technician - WC20 Sunkammurali Krishna Production Technician - WC20 Singh Paul Production Technician - WC20 Randall Cynthia Production Supervisor - WC30 Wang Jian Shuo Production Technician - WC30 Reátegui Alayo Sandra Production Technician - WC30 Watters Jason Production Technician - WC30 Ruth Andy Production Technician - WC30 Vanderhyde Michael Production Technician - WC30 Shabalin Rostislav Production Technician - WC30 Li Yuhong Production Supervisor - WC20 Feng Hanying Production Technician - WC20 Sam Raymond Production Technician - WC20 Fakhouri Fadi Production Technician - WC20 Sacksteder Lane Production Technician - WC20 Randall Linda Production Technician - WC20 Dyck Shelley Production Technician - WC20 Earls Terrence Production Technician - WC20 Hay Jeff Production Supervisor - WC45 Koenigsbauer Kirk Production Technician - WC45 Steele Laura Production Technician - WC45 Nayberg Alex Production Technician - WC45 Cencini Andrew Production Technician - WC45 Preston Chris Production Technician - WC45 Richins Jack Production Supervisor - WC30 Johnson David Production Technician - WC30 Young Garrett Production Technician - WC30 Metters Susan Production Technician - WC30 Li George Production Technician - WC30 Yalovsky David Production Technician - WC30 Ingle Marc Production Technician - WC30 Zabokritski Eugene Production Technician - WC30 Martin Benjamin Production Technician - WC30 Koch Reed Production Technician - WC30 Lawrence David Production Technician - WC30 King Russell Production Technician - WC30 Frum John Production Technician - WC30 Miksovsky Jan Production Technician - WC30 McAskill-White Katie Production Supervisor - WC20 Hines Michael Production Technician - WC20 Mirchandani Nitin Production Technician - WC20 Decker Barbara Production Technician - WC20 Chen John Production Technician - WC20 Hesse Stefen Production Technician - WC20 Kim Shane Production Supervisor - WC45 McKay Yvonne Production Technician - WC45 Hite Douglas Production Technician - WC45 Esteves Janeth Production Technician - WC45 Rounthwaite Robert Production Technician - WC45 Penuchot Lionel Production Technician - WC45 Diaz Brenda Production Supervisor - WC40 McGuel Alejandro Production Technician - WC40 Northup Fred Production Technician - WC40 Liu Kevin Production Technician - WC40 Mohamed Shammi Production Technician - WC40 Patel Rajesh Production Technician - WC40 Nay Lorraine Production Technician - WC40 Nartker Paula Production Technician - WC40 Lee Frank Production Technician - WC40 Lloyd Brian Production Technician - WC40 Nusbaum Tawana Production Technician - WC40 Myer Ken Production Technician - WC40 Mares Gabe Production Technician - WC40 Kane Lori Production Supervisor - WC45 Munson Stuart Production Technician - WC45 Alderson Greg Production Technician - WC45 Gode Scott Production Technician - WC45 Flood Kathie Production Technician - WC45 Newman Belinda Production Technician - WC45 Abolrous Hazem Quality Assurance Manager Wu Peng Quality Assurance Supervisor Charncherngkha Sootha Quality Assurance Technician Berglund Andreas Quality Assurance Technician Harrington Mark Quality Assurance Technician Alexander Sean Quality Assurance Technician Arifin Zainal Document Control Manager Kharatishvili Tengiz Control Specialist Chai Sean Document Control Assistant Berge Karen Document Control Assistant Norred Chris Control Specialist Wright A. Scott Master Scheduler Uddin Sairaj Scheduling Assistant Vong William Scheduling Assistant Brewer Alan Scheduling Assistant LaMee Brian Scheduling Assistant Altman Gary Facilities Manager Kleinerman Christian Maintenance Supervisor Penor Lori Janitor Macrae Stuart Janitor Berry Jo Janitor Coleman Pat Janitor Hedlund Magnus Facilities Administrative Assistant Norman Laura Chief Financial Officer Barreto de Mattos Paula Human Resources Manager Culbertson Grant Human Resources Administrative Assistant Chen Hao Human Resources Administrative Assistant Luthra Vidur Recruiter Martin Mindy Benefits Specialist Johnson Willis Recruiter Liu David Accounts Manager Poe Deborah Accounts Receivable Specialist Spoon Candy Accounts Receivable Specialist Walton Bryan Accounts Receivable Specialist Moreland Barbara Accountant Tomic Dragan Accounts Payable Specialist Sheperdigian Janet Accounts Payable Specialist Seamans Mike Accountant Kahn Wendy Finance Manager Word Sheela Purchasing Manager Sandberg Mikael Buyer Rao Arvind Buyer Meisner Linda Buyer Ogisu Fukiko Buyer Hee Gordon Buyer Pellow Frank Buyer Kurjan Eric Buyer Hagens Erin Buyer Miller Ben Buyer Hill Annette Purchasing Assistant Hillmann Reinout Purchasing Assistant Barber David Assistant to the Chief Financial Officer Trenary Jean Information Services Manager Conroy Stephanie Network Manager Sharma Ashvini Network Administrator Connelly Peter Network Administrator Berg Karen Application Specialist Meyyappan Ramesh Application Specialist Bacon Dan Application Specialist Ajenstat François Database Administrator Wilson Dan Database Administrator Bueno Janaina Application Specialist Welcker Brian Vice President of Sales Jiang Stephen North American Sales Manager Blythe Michael Sales Representative Mitchell Linda Sales Representative Carson Jillian Sales Representative Vargas Garrett Sales Representative Reiter Tsvi Sales Representative Ansman-Wolfe Pamela Sales Representative Ito Shu Sales Representative Saraiva José Sales Representative Campbell David Sales Representative Mensa-Annan Tete Sales Representative Abbas Syed Pacific Sales Manager Tsoflias Lynn Sales Representative Alberts Amy European Sales Manager Valdez Rachel Sales Representative Pak Jae Sales Representative Varkey Chudukatil Ranjit Sales Representative

Explanation / Answer

Assuming the table as db.Hours, the SQL query is as below,

SELECT [Job title], SUM(ISNULL([Week 3], 0) + ISNULL([Week 2], 0) + ISNULL([Week 1], 0) + ISNULL([Week 4], 0)) AS [Hours Worked]
FROM dbo.Hours
GROUP BY [Job title];

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.