Hi, I need the answer in word form or handwritten form.

1. (a) Refer to the tables below: Table Name: SALESPERSON ID NAME AGE STATE 1 Peter 22 Johor 2 Jane 35 Malacca 3 Alvin 32 Penang 4 Mike Kelantan 5 David 29 Pahang 6 John 31 Perak SALARY 2500 3500 1500 5500 9500 2500 50 6 7 Janet 42 Sabah 11000 Table Name: COMMISSION OID DATE SALESPERSON_ID AMOUNT 102 2017-10-08 00:00:00 3 13000 100 2016-10-08 00:00:00 3 7500 101 2015-11-20 00:00:00 2 2560 103 2016-05-20 00:00:00 4 3060 (i) Demonstrate FULL OUTER JOIN between SALESPERSON and COMMISSION tables based on ID and SALESPERSON_ID by providing the Hive Query Language (HiveQL). Note: The output should display only 4 columns which are ID, NAME (from SALESPERSON), AMOUNT and DATE (from COMMISSION). (4 marks) (ii) Present the output of the HiveQL (you provided in 1(a)(0) in a table. (4 marks)