1- The manager of the Savers Bank is willing to cluster their customer using the following criteria: • The amount of the

[answerhappygod]

1 The Manager Of The Savers Bank Is Willing To Cluster Their Customer Using The Following Criteria The Amount Of The 1 (75.9 KiB) Viewed 23 times

1- The manager of the Savers Bank is willing to cluster their customer using the following criteria: • The amount of the last transaction on the savings account • City • CVV To this end develop your SQL code using the three following steps a. Find the date of the last transaction for each customer using GROUP BY statement on SAVINGS_TRANS table. Obtain the amount using INVESTMEN column of the same table. b. Join M_CUSTOMERS and M_CREDIT_CARDS and get necessary columns. c. Join the two seperate tables in step a and step b using subqueries.