Search for question
Question

The owners decide to reward instructors with a bonus, at the end of the term. The bonus (a one-time

payout) is calculated, like so:

bonus = hourly_rate * sum_of_class_counts * 0.1

'sum_of_class_counts' is simply a total, of student count from each class an instructor taught - eg. if instructor Dat

taught JavaScript, Python and Scratch, with enrollments of 20, 20 and 15 students respectively, the

sum_of_class_counts for Dat will be 55 (if a student takes multiple courses - we count that student as many times,

not count them as 1). Also, this bonus is just for teaching, not for supervising projects.

Write a query that will output the highest bonus amount paid. Do feel free to create whatever table(s) you need, and

populate it/them with your own data.