Consider a query that aims to retrieve information about employees who received a total bonus of more than $10,000 between June 1st and…