Question: Produce the outputs requested by the SQL commands and draw the tables for the outputs. Answer the questions by referring to the table provided: Table

Produce the outputs requested by the SQL commands and draw the tables for the outputs. Answer the questions by referring to the table provided: Table name: salary start_id S001 S002 S003 S004 S005 S006 stall_name Ahmad Albab Osman Jailani Kassim Selamat Abdul Wahub Sulaiman Akhlaken Sabariah Mansur start_dept Human Resource Finance Procurement Human Resource Customer Service Finance stall_salary 5,000.00 5,970.00 4,345.00 3,500.00 2.200.00 5,500.00 a) SELECT * from staff WHERE staff_dept="Human Resource"; (4 marks) b) SELECT staff_name, staff_salary FROM staff ORDER BY staff salary ASC: (4 marks) c) SELECT DISTINCT staff_dept FROM staff: (2 marks) d) SELECT staff_name, staff_dept, staff_salary FROM staff ORDER BY stall_name DESC, (4 marks)
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
