Question: P 5 . 1 : For the table below, answer the questions table [ [ St . No . , Name,Surname,Department,Gender ] , [

P5.1: For the table below, answer the questions
\table[[St. No.,Name,Surname,Department,Gender],[20203454,Abdullah,Asani,Bioengineering,Male],[20195412,Abdullah,Bari,Civil Engincering,Male],[20200743,Nelson,Asani,Civil Engineering,Male],[20187904,Marie,Ngoyi,Computer Engineering,Female],[20192153,Ahmed,Jabar,Civil Engineering,Male],[20190032,Bilal,Khan,Mechanical Engineering,Male],[20201023,Sultan,Ghanam,Bioengineering,Female]]
a) Sort the table by Surname from A to Z.
b) Sort the table by Gender (A to Z) then by Name (A to Z) then by Department to A).
c) Filter the table and show Female in Bioengineering department only.
 P5.1: For the table below, answer the questions \table[[St. No.,Name,Surname,Department,Gender],[20203454,Abdullah,Asani,Bioengineering,Male],[20195412,Abdullah,Bari,Civil Engincering,Male],[20200743,Nelson,Asani,Civil

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!