**Note: Please post the answer in SQL query to be implemented on DB browser SQLITE**

Table: Employee Filter in any column EMPLOYEE_ID FIRST_NAME LAST_NAME SALARY JOINING_DATE DEPARTMENT MANAGER_ID Filter Filter Filter Filter Filter Filter Filter 1 1 James Smith 100000 17-02-20 09.00.00 HR 2 2 2 Jessica Kohl 80000 17-06-11 09.00.00 Admin 5 3 3 Alex Garner 300000 17-02-20 09.00.00 HR 11 4 4 Pratik Pandey 500000 17-02-20 09.00.00 Admin 20 5 5 Christine Robinson 500000 17-06-11 09.00.00 Admin 7 6 6 Deepak Gupta 200000 17-06-11 09.00.00 Account 15 7 7 Jennifer Paul 75000 17-01-20 09.00.00 Account 12 8 8 Deepika Sharm 90000 17-04-11 09.00.00 Admin 17 7 Table: Bonus C EMPLOYEE_REF_ID BONUS_AMOUNT Filter Filter 1 1 5000 2 3000 3 3 4000 BONUS_DATE Filter 18-02-20 18-06-11 18-02-20 18-02-20 18-06-11 min 4 1 4500 2 3500 5 Q1). You are given a Company.db file. Write an SQL Query to find Empoyee_ID, Employee Name and the total bonus each employee received. Your final output should contain three columns: Employee_ID', 'Name' and *Total_Bonus'. Your Name Column should be first name followed by last name. The Total_Bonus' column is the total bonus of those employees who where awarded bonus. If your query executes correctly, you should be getting the following result (3 records will be returned) 1 EMPLOYEE_ID Name 1 James Smith 2 Jessica Kohl 3 Alex Garner Total_Bonus 9500 6500 4000 2 Nm 3