Page 1 of 1
1- The manager of the Savers Bank is willing to cluster their customer using the following criteria: • The amount of the
Posted: Thu Jun 02, 2022 8:32 am
by 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 24 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.