Using SQl DDL write sql commands for

1_Retrieve the number of transactions for each account during the year 2019 (Returns 8 records)

2_Update the Status of account of customer Ryan Ishus to Active. 3_Delete the loans which their loan period is NULL.

=-=-=- Account: Account_number Customer_id Status Branch_code b3 Balance Opening_date 16003 2018-12-31 ac1055 10035 Active ac1103 10020 b2 18124 2015-08-02 Active ac1114 10061 b2 12978 2020-10-06 Inactive ac1118 10012 b2 15225 2015-06-11 Active ac1135 10045 b1 8411 2019-06-02 Active ac1157 10003 b1 18693 2016-09-21 Inactive ac1163 10019 b1 18154 2020-02-23 Active ac1183 10068 b2 14868 2016-01-29 Inactive ac1194 10039 b4 11820 2019-03-22 Active ac1224 10032 b1 9801 2018-10-19 Active ac1230 10013 b3 17477 2017-09-25 Inactive ac1234 10027 b1 13656 2018-03-07 Inactive ac1238 10045 b1 11398 2017-01-14 Inactive ac1259 10013 b3 18387 2019-10-18 Active ac1267 10022 b1 17374 2015-11-24 Active ac1327 10009 b4 10839 2019-10-27 Active ac 1452 10035 b3 19748 2017-11-04 Inactive Active ac1458 10039 b4 11479 2017-02-21 ac 1470 10005 b2 11207 2015-03-26 Active ac1471 10027 b1 9117 2018-03-05 Inactive Branch: Name City Branch_code Address Manager Gjvik Branch Gjvik b1 Storgata 55 Alexander Dahl Trondheim Branch Trondheim b2 Strindvegen 7 Martina Jensen Oslo Branch Oslo b3 Bromstadvegen 31 Tom Westin Lillehammer Branch Lillehammer b4 Anders Tvereggens veg 12 John Smith Hamar Branch Hamar Lille Strandgate 2 Otto Roseth b5 Arendal Branch Arendal b6 Strandgata 71 Sofie Hovde Customer: Name Customer_id Gender Birth_date City Address Postal_code Home_Phone Mobile_phone Email 10003 F 2000-04-28 Gjvik Moholt alle 4 2816 59575468 39305691 hildegunn@realmail.no Hildegunn Eggen Sofie Veierod 10005 F 1996-03-21 Trondheim Frode Rinnans veg 27 7036 35904273 30254098 sofie@yahoo.com Christoffer Sande 10009 M 1972-02-26 Lillehammer Hans Baucks veg 48 2611 50742474 71218150 christoffer@yahoo.com Ema Kaasa 10012 F 1978-05-20 Trondheim Valentinlystvegen 43 7034 70536071 83358256 erna@yahoo.com Benjamin Kringen 10013 M 1965-12-15 Oslo Lidarende 33 0151 43828201 67896305 benjamin@realmail.no Vivi Sando 10019 F 1958-07-29 Gjvik Astri Aasens veg 12 2821 35745929 78088625 vivi@realmail.no Audun Owe 10020 M 1964-06-22 7026 84561135 25715331 audun@rocketmail.no Trondheim Frydenbergvegen 41 Kasper Andresens veg Gjvik 45 Markus Stenseth 10022 M 1950-04-26 2816 25200362 59268004 markus@realmail.no Silje Henjum 10027 F 1983-06-03 Gjvik Sigurd Jorsalfars veg 28 2818 30420382 77112631 silje@realmail.no Agnar Nielsen 10032 M 1980-05-19 Gjvik Herman Krags veg 21 2817 39585170 57974878 agnar@rocketmail.no Monika Narum 10035 F 1958-07-29 Oslo Jonsvannsveien 5 0259 87867556 23033394 monika@yahoo.com Ina Huseby 10039 F 1984-01-09 Lillehammer Nordre Eberg gate 55 2614 57612202 33548835 ina@rocketmail.no Lillian Eriksen 10045 F 1997-09-15 Gjvik Kong ysteins veg 8 2819 89078833 81098988 lillian@rocketmail.no Ulrik Bergland 10061 M 1990-03-11 Trondheim Jonsvannsveien 13 7028 50099414 26901503 ulrik@gmail.com Audun Strand 10068 M 1999-02-28 Trondheim Svalevegen 23 7017 46456081 81924867 audun@realmail.no Depositor: Transaction_id Account_number Amount Date Customer_id 10013 tr1239 ac1259 450 2020-05-13 tr1244 10068 ac1183 400 2020-10-13 tr1271 10035 ac 1452 1000 2020-08-04 tr1290 10013 ac1230 1150 2019-07-08 tr1296 10009 ac 1327 2500 2019-08-22 tr1311 10019 ac 1163 200 2020-06-14 tr1317 10009 ac1327 1200 2020-09-15 tr1325 10009 ac1327 300 2019-03-20 tr1328 10039 ac1194 250 2019-05-04 tr1332 10019 ac 1163 600 2019-04-19 t1344 10012 ac1118 450 2019-04-14 tr1345 10061 ac1114 250 2019-07-08 tr1346 10013 ac1259 1000 2019-04-04 tr1352 10013 ac1230 300 2020-12-30 tr1369 10039 ac1194 400 2020-02-01 tr1398 10005 ac1470 500 2020-05-14 tr1405 10022 ac1267 1100 2020-03-17 tr1407 10061 ac 1114 1200 2020-12_15 tr1418 10020 ac 1103 850 2019-03-09 tr1421 10005 ac1470 1300 2020-03-14 Loan: Loan_amount Starting_Date Loan_number lo 1004 Customer_id Branch_code Loan_name 10013 b2 Personal Loan_period Interest_rate 3 1.88% 50000 2018-05-03 lo 1029 10027 64 Car 100000 2020-09-27 10 2.49% lo 1031 10009 b1 Personal 50000 2018-12-27 3 1.88% lo 1044 10035 b2 Home 100000 2018-06-08 5 2.13% lo 1062 10020 b3 Car 50000 2020-07-26 3 1.88% lo 1065 10039 b3 Personal 20000 2018-08-29 3 1.88% lo 1075 10012 b4 Personal 30000 2019-09-02 3 1.88% lo 1131 10061 b2 Home 200000 2019-07-30 10 2.49% lo1135 10032 b4 Car 100000 2020-01-15 5 2.13% lo1141 10027 b3 Personal 25000 2020-07-05 3 1.88% lo1185 10039 b3 Personal 50000 2018-08-10 3 1.88% lo 1210 10005 b4 Home 100000 2020-12-30 5 2.13% lo1275 10068 b1 Personal NULL 2018-09-02 NULL 1.88% 101285 10032 b2 Personal 30000 2019-12-29 3 1.88% lo 1286 10020 b4 Personal NULL 2018-04-09 NULL 1.88%