Add 0.5 percent to the commission rate of agents who have sold more than $20,000 in engagements. (Hint: Use an aggregate subquery to find those agents HAVING total bookings greater than $20,000.) +++
| CommissionRate | NewCommissionRate |
+++
| 0.05 | 0.05500000074505806 |
| 0.045 | 0.05000000178813934 |
| 0.06 | 0.0649999986588955 |
+++
(3 rows changed)

Pp 4.1 design and implement a class called sphere that contains instance data that represents the sphere’s diameter. define the sphere constructor to accept and initialize the diameter and include getter and setter methods for the diameter. include methods that calculate and return the volume and surface area of the sphere (see pp 3.5 for the formulas). include a tostring method that returns a one-line description of the sphere. create a driver class called multisphere, whose main method instantiates and updates several sphere objects.