In SQL

. (1 point) Create a data frame that contains a list of customer_id whose sum amount of payment in 2005 is more than $200. Result should be as follows for self verification purpose. Out[66]: amount customer_id 148 216.54 526 221.55 . (1 point) Merge/join the result with customer data frame set to get their names. Result should be as follows for self verification purpose. Out [64]: first_name last name amount O ELEANOR HUNT 216.54 KARL SEAL 221.55 (2 points) Create a data frame that contains a list of customer_id that rented in 2005; Create another data frame that contains a list of customer_id that rented in 2006 (filter using rental_date). a. (1 point) Now create a data frame of customer_id that exist in the 2005 data frame but not in the 2006 data frame. The count should be 441. b. (1 point) Now . (1 point) Create a data frame that contains a list of customer_id whose sum amount of payment in 2005 is more than $200. Result should be as follows for self verification purpose. Out[66]: amount customer_id 148 216.54 526 221.55 . (1 point) Merge/join the result with customer data frame set to get their names. Result should be as follows for self verification purpose. Out [64]: first_name last name amount O ELEANOR HUNT 216.54 KARL SEAL 221.55 (2 points) Create a data frame that contains a list of customer_id that rented in 2005; Create another data frame that contains a list of customer_id that rented in 2006 (filter using rental_date). a. (1 point) Now create a data frame of customer_id that exist in the 2005 data frame but not in the 2006 data frame. The count should be 441. b. (1 point) Now