Question: By seeing this csv file named employee-sample, can you write the following SQL queries: Write an SQL query to list the names, department, and division
By seeing this csv file named "employee-sample", can you write the following SQL queries:
- Write an SQL query to list the names, department, and division of all part-time employees, who earn a current annual salary higher than $60,000.
- Write an SQL query to list the names of all departments that have employees paid over $150,000 (GROSS PAID); each such department must be listed only once.
B D E G H 1 Full_Name Current_Annual_Salary Gross_Pay_Received Overtime_Department Division Assignment_Category Position_Title 2 Aaby Katherine Ann 113185 107896 O HHS Public Hea Fulltime-Regular Manager III 3 Aarhus Pam J 65402 67874 916 POL MSB Infor Fulltime-Regular Office Services Coordinator 4 Acea-Green Ernesto 53547 64074 9218 DOT Transit Sil Fulltime-Regular Bus Operator 5 Acevedo Magda C 40028 41597 126 HHS Montgome Fulltime-Regular Office Services Coordinator 6 Acharya Namita S 74784 70594 0 CCL Council Ce Fulltime-Regular Program Manager 7 Achiaw Mabel O 86687 85148 O HHS Medical As Fulltime-Regular Income Assistance Program Specialist III 8 Acken Brian 112772 102054 O POL MSB Infor Fulltime-Regular Manager 11 9 Adcock Sr Gerald W 98315 94370 O DTS COO Offic Fulltime-Regular Senior Information Technology Specialist 10 Adami Michael E 72070 76681 2007 POL ISB Crimin: Fulltime-Regular Police Officer III 11 Adams Anthony Joseph 38389 53904 15933 DOT Transit Silv Fulltime-Regular Bus Operator 12 Adams Bruce T 166281 162387 Communit Fulltime-Regular Director Office of Community Partnerships 13 Bingham Richard A 77697 76002 Business | Fulltime-Regular Program Manager 14 Birch Errol O. 102325 121004 11887 POL ISB Family Fulltime-Regular Police Sergeant 15 Bird Alice M. 91329 86633 O HHS School He: Fulltime-Regular Community Health Nurse II 16 Birenbaum Robert J 82751 80238 Zoning, Lar Fulltime-Regular Assistant County Attorney III 17 Birk Catherine D 73114 80751 2460 POL HQ Office Fulltime-Regular Master Police Officer 18 Birndorf Rashi A 35889 34748 2385 DEP Solid Wast Fulltime-Regular Public Service Worker II 19 Birney Jaymie R 55991 61980 4169 FRS Station 3 Fulltime-Regular Firefighter/Rescuer III 20 Birton John B JR 79354 86787 11712 DOT Highway S Fulltime-Regular Highway Construction Field Supervisor 21 Bise James T 75957 92995 19563 FRS Fourth Bat Fulltime-Regular Fire/Rescue Lieutenant 22 Bise Mary L 44342 48451 4370 POL MSB Infori Fulltime-Regular Office Services Coordinator 23 Biser Terry L 56878 56627 787 HHS Income Su Fulltime-Regular Principal Administrative Aide 24 Bishop Audrey S. 28439 29100 O LIB Aspen Hill Parttime-Regular Library Assistant 25 Bishop Cheryl C 60736 58562 396 DGS Fleet Man Fulltime-Regular Office Services Coordinator 26 Bishop Martha A 55063 52994 650 HHS Income Su Fulltime-Regular Income Assistance Program Specialist II 27 Bishop Trent E 96665 95762 4117 POL MSB Comr Fulltime-Regular Information Technology Specialist III 28 Bisrat Abnet 48835 55601 9310 DLC Purchasing Fulltime-Regular Alcohol Beverage Purchasing Specialist employee-sample (1) + J Date_First_Hired 1/4/1988 ######## 3/5/2000 ######## ######## ######## 4/9/2012 ######## ######## ######## ######## ######## 9/8/1987 ######## ######## ######## ######## ######## ######## 6/7/2004 1/5/2009 ######## ######## ######## ######## ######## 5/3/2004
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
