Write the SQL Commands to perform the following:

Show the manager name, their department, and their department costs.

Show the employees first and last name that live in cypress

Show how much bonus each employee will get $-$ show last name and bonus amount

For each employee show their last name and how much they are paid assuming a payrate and $40$ hours worked

Show the employee last name, their department, and the city in which they live.

Put your select staatements in the Text Field for this assignment.