Write procedure BabysitterSalary in SQL server to determine the salary obtained by a babysitter based on her working hours. The procedure must take...

Write  procedure   BabysitterSalary in SQL server  to  determine the salary obtained by a babysitter based on her working hours. The procedure must take time in, time out and the number of children. The charging per hour is varies based on different shift. The babysitter can work a maximum of 24 hours.

   Shift                                               Charging per hour (for 1 child)

09.00 A.M - 15.00 P.M                        $ 300

15.01 P.M - 21.00 P.M                        $ 400

21.01 P.M - 08.59 A.M                        $ 600

If the number of children is equal to 2, the charging per hour increase by 50% for all shift  else if the number of children is more than 2, the charging per hour increase by 100%

For example  if the babysitter has worked from 10.00 A.M till 13.00 P.M  and babysit 1 child then her salary will be (3 * 300)= $900

                      if the babysitter has worked from 10.00 A.M till  17.00 P.M and babysit  1 child then her salary will be ( (5*300) + ( 2*400) ) = $ 2300