Aggregation functions. Use the following account table as an example, explain how to implement each of the following (no need to consider optimization) (a) Sorting based approach to implement sum function, such as branch-name G sumbalance) (account) (b) Hashing based approach to implement count function, such as G counthalance) (account) Account table account-number branch-name balance Downtown 500 A-101 A-102Perryridge400 A-201 Brighton900 A-215 A-217 A-222 A-305 700 750 700 Mianus Brighton Redwood Round Hil 350 Aggregation functions. Use the following account table as an example, explain how to implement each of the following (no need to consider optimization) (a) Sorting based approach to implement sum function, such as branch-name G sumbalance) (account) (b) Hashing based approach to implement count function, such as G counthalance) (account) Account table account-number branch-name balance Downtown 500 A-101 A-102Perryridge400 A-201 Brighton900 A-215 A-217 A-222 A-305 700 750 700 Mianus Brighton Redwood Round Hil 350