Employee payment system

Employee name: *

Payment type:

Payment amount (max 999999)



Display information in different ways

Display information in its original way
Sort by name in ascending order
Find someone makes how much money (name: )
Find each one makes how much money in total and sort results in descending order
Find payments for different types (type: )
Find the employee with highest bonus
Find the total payments for the 3 categories

nametypeamountpaymentID
Danielbonus100001
Ryansalary80002
Vanesaother303
Vanesaother304
Vanesaother305
Connorbonus9996
Georgiasalary9090907
Johnnyother558
Donaldother10009
Parkerbonus30010
Jacksalary550011
Grizzlybonus10012
There are totally 12 records