/
ArtiWell
/
t1_java
Обзор
Документация
Войти
/
ArtiWell
/
t1_java
Код
Запросы
1
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
start
src/main/resources/Accounts.sql
200 строк
17 KB
artem.s
Задание 1 АОР
05 ноя 2024, 21:08
05 ноя 2024, 21:08
759514a
Код
Авторство
О чём код?
insert into account (client_id, account_type, balance) values (1, 'CREDIT', 504087); insert into account (client_id, account_type, balance) values (90, 'CREDIT', 918512); insert into account (client_id, account_type, balance) values (27, 'DEBIT', 8412); insert into account (client_id, account_type, balance) values (87, 'CREDIT', 1804); insert into account (client_id, account_type, balance) values (45, 'CREDIT', 422355); insert into account (client_id, account_type, balance) values (84, 'CREDIT', 3197); insert into account (client_id, account_type, balance) values (63, 'DEBIT', 257461); insert into account (client_id, account_type, balance) values (80, 'CREDIT', 440064); insert into account (client_id, account_type, balance) values (86, 'CREDIT', 766955); insert into account (client_id, account_type, balance) values (63, 'DEBIT', 926412); insert into account (client_id, account_type, balance) values (94, 'DEBIT', 21552); insert into account (client_id, account_type, balance) values (19, 'CREDIT', 682518); insert into account (client_id, account_type, balance) values (16, 'CREDIT', 909586); insert into account (client_id, account_type, balance) values (52, 'DEBIT', 919658); insert into account (client_id, account_type, balance) values (69, 'DEBIT', 57694); insert into account (client_id, account_type, balance) values (60, 'DEBIT', 637895); insert into account (client_id, account_type, balance) values (17, 'DEBIT', 569304); insert into account (client_id, account_type, balance) values (15, 'DEBIT', 790713); insert into account (client_id, account_type, balance) values (70, 'DEBIT', 781943); insert into account (client_id, account_type, balance) values (97, 'DEBIT', 313128); insert into account (client_id, account_type, balance) values (55, 'CREDIT', 135546); insert into account (client_id, account_type, balance) values (95, 'CREDIT', 816355); insert into account (client_id, account_type, balance) values (63, 'DEBIT', 963723); insert into account (client_id, account_type, balance) values (31, 'CREDIT', 829499); insert into account (client_id, account_type, balance) values (91, 'DEBIT', 319903); insert into account (client_id, account_type, balance) values (24, 'CREDIT', 183263); insert into account (client_id, account_type, balance) values (44, 'CREDIT', 531555); insert into account (client_id, account_type, balance) values (7, 'DEBIT', 848598); insert into account (client_id, account_type, balance) values (55, 'CREDIT', 942175); insert into account (client_id, account_type, balance) values (15, 'DEBIT', 968939); insert into account (client_id, account_type, balance) values (27, 'CREDIT', 247318); insert into account (client_id, account_type, balance) values (8, 'CREDIT', 266870); insert into account (client_id, account_type, balance) values (59, 'DEBIT', 471723); insert into account (client_id, account_type, balance) values (19, 'DEBIT', 320698); insert into account (client_id, account_type, balance) values (72, 'DEBIT', 567699); insert into account (client_id, account_type, balance) values (43, 'DEBIT', 838208); insert into account (client_id, account_type, balance) values (77, 'CREDIT', 238334); insert into account (client_id, account_type, balance) values (19, 'DEBIT', 107405); insert into account (client_id, account_type, balance) values (79, 'CREDIT', 253695); insert into account (client_id, account_type, balance) values (46, 'CREDIT', 489354); insert into account (client_id, account_type, balance) values (12, 'CREDIT', 176129); insert into account (client_id, account_type, balance) values (32, 'DEBIT', 733856); insert into account (client_id, account_type, balance) values (7, 'CREDIT', 12051); insert into account (client_id, account_type, balance) values (23, 'CREDIT', 460385); insert into account (client_id, account_type, balance) values (13, 'DEBIT', 948624); insert into account (client_id, account_type, balance) values (10, 'DEBIT', 70756); insert into account (client_id, account_type, balance) values (12, 'DEBIT', 271761); insert into account (client_id, account_type, balance) values (79, 'CREDIT', 529580); insert into account (client_id, account_type, balance) values (78, 'CREDIT', 519932); insert into account (client_id, account_type, balance) values (89, 'DEBIT', 941857); insert into account (client_id, account_type, balance) values (20, 'CREDIT', 162680); insert into account (client_id, account_type, balance) values (94, 'CREDIT', 906795); insert into account (client_id, account_type, balance) values (72, 'DEBIT', 322337); insert into account (client_id, account_type, balance) values (22, 'CREDIT', 945936); insert into account (client_id, account_type, balance) values (41, 'CREDIT', 466786); insert into account (client_id, account_type, balance) values (88, 'DEBIT', 798536); insert into account (client_id, account_type, balance) values (58, 'CREDIT', 201652); insert into account (client_id, account_type, balance) values (45, 'DEBIT', 954723); insert into account (client_id, account_type, balance) values (23, 'DEBIT', 143872); insert into account (client_id, account_type, balance) values (15, 'DEBIT', 722148); insert into account (client_id, account_type, balance) values (3, 'CREDIT', 258936); insert into account (client_id, account_type, balance) values (22, 'CREDIT', 622378); insert into account (client_id, account_type, balance) values (22, 'CREDIT', 975794); insert into account (client_id, account_type, balance) values (29, 'DEBIT', 891794); insert into account (client_id, account_type, balance) values (9, 'DEBIT', 697233); insert into account (client_id, account_type, balance) values (39, 'CREDIT', 519883); insert into account (client_id, account_type, balance) values (97, 'DEBIT', 313552); insert into account (client_id, account_type, balance) values (33, 'CREDIT', 885468); insert into account (client_id, account_type, balance) values (5, 'CREDIT', 106060); insert into account (client_id, account_type, balance) values (12, 'DEBIT', 155079); insert into account (client_id, account_type, balance) values (59, 'DEBIT', 651771); insert into account (client_id, account_type, balance) values (13, 'DEBIT', 646647); insert into account (client_id, account_type, balance) values (9, 'DEBIT', 936728); insert into account (client_id, account_type, balance) values (27, 'CREDIT', 340390); insert into account (client_id, account_type, balance) values (28, 'DEBIT', 619619); insert into account (client_id, account_type, balance) values (70, 'CREDIT', 931994); insert into account (client_id, account_type, balance) values (82, 'CREDIT', 638967); insert into account (client_id, account_type, balance) values (16, 'CREDIT', 822968); insert into account (client_id, account_type, balance) values (100, 'CREDIT', 273364); insert into account (client_id, account_type, balance) values (95, 'CREDIT', 371570); insert into account (client_id, account_type, balance) values (83, 'CREDIT', 329887); insert into account (client_id, account_type, balance) values (13, 'CREDIT', 905347); insert into account (client_id, account_type, balance) values (56, 'DEBIT', 551489); insert into account (client_id, account_type, balance) values (93, 'DEBIT', 146764); insert into account (client_id, account_type, balance) values (11, 'DEBIT', 798381); insert into account (client_id, account_type, balance) values (97, 'CREDIT', 247768); insert into account (client_id, account_type, balance) values (55, 'DEBIT', 24091); insert into account (client_id, account_type, balance) values (34, 'CREDIT', 399184); insert into account (client_id, account_type, balance) values (58, 'CREDIT', 165267); insert into account (client_id, account_type, balance) values (75, 'CREDIT', 327256); insert into account (client_id, account_type, balance) values (88, 'DEBIT', 948117); insert into account (client_id, account_type, balance) values (90, 'CREDIT', 225245); insert into account (client_id, account_type, balance) values (5, 'CREDIT', 842651); insert into account (client_id, account_type, balance) values (69, 'DEBIT', 799286); insert into account (client_id, account_type, balance) values (90, 'CREDIT', 381526); insert into account (client_id, account_type, balance) values (80, 'CREDIT', 911440); insert into account (client_id, account_type, balance) values (63, 'DEBIT', 22336); insert into account (client_id, account_type, balance) values (76, 'DEBIT', 486601); insert into account (client_id, account_type, balance) values (46, 'DEBIT', 195276); insert into account (client_id, account_type, balance) values (84, 'DEBIT', 813393); insert into account (client_id, account_type, balance) values (81, 'DEBIT', 157015); insert into account (client_id, account_type, balance) values (49, 'CREDIT', 550542); insert into account (client_id, account_type, balance) values (37, 'DEBIT', 130809); insert into account (client_id, account_type, balance) values (83, 'DEBIT', 746314); insert into account (client_id, account_type, balance) values (18, 'DEBIT', 913440); insert into account (client_id, account_type, balance) values (10, 'DEBIT', 672174); insert into account (client_id, account_type, balance) values (36, 'CREDIT', 638288); insert into account (client_id, account_type, balance) values (71, 'DEBIT', 194712); insert into account (client_id, account_type, balance) values (31, 'CREDIT', 33130); insert into account (client_id, account_type, balance) values (17, 'DEBIT', 396007); insert into account (client_id, account_type, balance) values (62, 'DEBIT', 241510); insert into account (client_id, account_type, balance) values (63, 'CREDIT', 96479); insert into account (client_id, account_type, balance) values (98, 'CREDIT', 546861); insert into account (client_id, account_type, balance) values (6, 'CREDIT', 217743); insert into account (client_id, account_type, balance) values (40, 'CREDIT', 169674); insert into account (client_id, account_type, balance) values (73, 'DEBIT', 395181); insert into account (client_id, account_type, balance) values (73, 'DEBIT', 480893); insert into account (client_id, account_type, balance) values (89, 'DEBIT', 932754); insert into account (client_id, account_type, balance) values (41, 'DEBIT', 734684); insert into account (client_id, account_type, balance) values (17, 'DEBIT', 326834); insert into account (client_id, account_type, balance) values (58, 'DEBIT', 30303); insert into account (client_id, account_type, balance) values (29, 'CREDIT', 662130); insert into account (client_id, account_type, balance) values (100, 'DEBIT', 221368); insert into account (client_id, account_type, balance) values (6, 'CREDIT', 471248); insert into account (client_id, account_type, balance) values (23, 'DEBIT', 362509); insert into account (client_id, account_type, balance) values (1, 'DEBIT', 290683); insert into account (client_id, account_type, balance) values (12, 'CREDIT', 487961); insert into account (client_id, account_type, balance) values (13, 'CREDIT', 661506); insert into account (client_id, account_type, balance) values (26, 'CREDIT', 34860); insert into account (client_id, account_type, balance) values (71, 'CREDIT', 512170); insert into account (client_id, account_type, balance) values (69, 'CREDIT', 308486); insert into account (client_id, account_type, balance) values (85, 'DEBIT', 897383); insert into account (client_id, account_type, balance) values (99, 'CREDIT', 484803); insert into account (client_id, account_type, balance) values (68, 'DEBIT', 831662); insert into account (client_id, account_type, balance) values (53, 'DEBIT', 162627); insert into account (client_id, account_type, balance) values (63, 'DEBIT', 748936); insert into account (client_id, account_type, balance) values (10, 'DEBIT', 846979); insert into account (client_id, account_type, balance) values (58, 'DEBIT', 646506); insert into account (client_id, account_type, balance) values (15, 'CREDIT', 316733); insert into account (client_id, account_type, balance) values (77, 'CREDIT', 572718); insert into account (client_id, account_type, balance) values (65, 'CREDIT', 858261); insert into account (client_id, account_type, balance) values (61, 'CREDIT', 322401); insert into account (client_id, account_type, balance) values (79, 'CREDIT', 840190); insert into account (client_id, account_type, balance) values (61, 'CREDIT', 479654); insert into account (client_id, account_type, balance) values (77, 'DEBIT', 697257); insert into account (client_id, account_type, balance) values (27, 'DEBIT', 385594); insert into account (client_id, account_type, balance) values (42, 'DEBIT', 697895); insert into account (client_id, account_type, balance) values (7, 'CREDIT', 356585); insert into account (client_id, account_type, balance) values (33, 'CREDIT', 176849); insert into account (client_id, account_type, balance) values (64, 'CREDIT', 345498); insert into account (client_id, account_type, balance) values (84, 'DEBIT', 191163); insert into account (client_id, account_type, balance) values (67, 'CREDIT', 663889); insert into account (client_id, account_type, balance) values (74, 'CREDIT', 476638); insert into account (client_id, account_type, balance) values (65, 'DEBIT', 217492); insert into account (client_id, account_type, balance) values (68, 'CREDIT', 389141); insert into account (client_id, account_type, balance) values (16, 'DEBIT', 406989); insert into account (client_id, account_type, balance) values (94, 'CREDIT', 484622); insert into account (client_id, account_type, balance) values (58, 'CREDIT', 559531); insert into account (client_id, account_type, balance) values (65, 'CREDIT', 152474); insert into account (client_id, account_type, balance) values (19, 'DEBIT', 423941); insert into account (client_id, account_type, balance) values (98, 'CREDIT', 623287); insert into account (client_id, account_type, balance) values (14, 'CREDIT', 307343); insert into account (client_id, account_type, balance) values (12, 'DEBIT', 969419); insert into account (client_id, account_type, balance) values (65, 'CREDIT', 810076); insert into account (client_id, account_type, balance) values (40, 'DEBIT', 492304); insert into account (client_id, account_type, balance) values (87, 'CREDIT', 747193); insert into account (client_id, account_type, balance) values (58, 'CREDIT', 553937); insert into account (client_id, account_type, balance) values (24, 'DEBIT', 816198); insert into account (client_id, account_type, balance) values (95, 'DEBIT', 490533); insert into account (client_id, account_type, balance) values (4, 'DEBIT', 103743); insert into account (client_id, account_type, balance) values (89, 'DEBIT', 547993); insert into account (client_id, account_type, balance) values (92, 'DEBIT', 116990); insert into account (client_id, account_type, balance) values (30, 'DEBIT', 724722); insert into account (client_id, account_type, balance) values (20, 'DEBIT', 489181); insert into account (client_id, account_type, balance) values (91, 'CREDIT', 34266); insert into account (client_id, account_type, balance) values (44, 'CREDIT', 558072); insert into account (client_id, account_type, balance) values (69, 'CREDIT', 450420); insert into account (client_id, account_type, balance) values (95, 'DEBIT', 182537); insert into account (client_id, account_type, balance) values (97, 'DEBIT', 819231); insert into account (client_id, account_type, balance) values (90, 'CREDIT', 395339); insert into account (client_id, account_type, balance) values (78, 'CREDIT', 163636); insert into account (client_id, account_type, balance) values (69, 'DEBIT', 483928); insert into account (client_id, account_type, balance) values (48, 'CREDIT', 441661); insert into account (client_id, account_type, balance) values (91, 'DEBIT', 4975); insert into account (client_id, account_type, balance) values (83, 'CREDIT', 834357); insert into account (client_id, account_type, balance) values (92, 'CREDIT', 522290); insert into account (client_id, account_type, balance) values (59, 'CREDIT', 978271); insert into account (client_id, account_type, balance) values (14, 'DEBIT', 854175); insert into account (client_id, account_type, balance) values (80, 'CREDIT', 220623); insert into account (client_id, account_type, balance) values (79, 'DEBIT', 852715); insert into account (client_id, account_type, balance) values (30, 'CREDIT', 469865); insert into account (client_id, account_type, balance) values (94, 'CREDIT', 877283); insert into account (client_id, account_type, balance) values (61, 'DEBIT', 503613); insert into account (client_id, account_type, balance) values (43, 'DEBIT', 178257); insert into account (client_id, account_type, balance) values (40, 'DEBIT', 181305); insert into account (client_id, account_type, balance) values (6, 'DEBIT', 481920); insert into account (client_id, account_type, balance) values (17, 'CREDIT', 852685); insert into account (client_id, account_type, balance) values (69, 'CREDIT', 314376); insert into account (client_id, account_type, balance) values (84, 'CREDIT', 645622); insert into account (client_id, account_type, balance) values (73, 'DEBIT', 5196);