Student Sid SFname SLname DOB Marks Specialization CourselD S101 Asra Hamed 2/3/2000 85 Human Resource HR11 S102 Alia Said 3/4/2001 60 Human Resource HR12 S103 Omer Khalid 5/1/2001 72 Marketing MKT11...


Write a query to display the average and total of student count of human resource specialization?


Please answer me faaast


Student<br>Sid<br>SFname<br>SLname<br>DOB<br>Marks<br>Specialization<br>CourselD<br>S101<br>Asra<br>Hamed<br>2/3/2000<br>85<br>Human Resource<br>HR11<br>S102<br>Alia<br>Said<br>3/4/2001<br>60<br>Human Resource<br>HR12<br>S103<br>Omer<br>Khalid<br>5/1/2001<br>72<br>Marketing<br>MKT11<br>S104<br>Huda<br>Saif<br>4/7/1999<br>63<br>Marketing<br>MKT11<br>S105<br>Hamed<br>Ahmed<br>3/5/2002<br>65<br>Human Resource<br>HR11<br>S106<br>Omer<br>Salim<br>4/5/2002<br>78<br>Accounting<br>АСC11<br>Course<br>CourselD<br>CourseName<br>CourseDate<br>PassMark<br>SCount<br>АСC11<br>Accounting1<br>9/3/2020<br>55<br>20<br>HR11<br>HRM1<br>9/4/2020<br>55<br>18<br>HR12<br>IHRM<br>9/7/2020<br>60<br>22<br>MKT11<br>Sales<br>9/5/2020<br>55<br>24<br>МKT12<br>Promotion<br>9/3/2020<br>60<br>16<br>

Extracted text: Student Sid SFname SLname DOB Marks Specialization CourselD S101 Asra Hamed 2/3/2000 85 Human Resource HR11 S102 Alia Said 3/4/2001 60 Human Resource HR12 S103 Omer Khalid 5/1/2001 72 Marketing MKT11 S104 Huda Saif 4/7/1999 63 Marketing MKT11 S105 Hamed Ahmed 3/5/2002 65 Human Resource HR11 S106 Omer Salim 4/5/2002 78 Accounting АСC11 Course CourselD CourseName CourseDate PassMark SCount АСC11 Accounting1 9/3/2020 55 20 HR11 HRM1 9/4/2020 55 18 HR12 IHRM 9/7/2020 60 22 MKT11 Sales 9/5/2020 55 24 МKT12 Promotion 9/3/2020 60 16

Jun 09, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here