ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
knowing that status 5 equals to' loan issued' and status 6 to 'cancelled'
3
please write PostgreSQL queries and provide the answers to the following questions:
4
5
1
how many loans are issued each month?
6
2
which team issued more loans (team A or team B)?
7
3
which loan agent issued the most loans?
8
4
please breakdown sales by loan value (in 1k ranges)
9
5
how many clients have taken a second loan?
10
6
on average, how long after payout do clients take a second loan?
11
7
which weekday is the most popular to take a loan?
12
8
which loan type is the most popular?
13
9
how many applications do we have per source? which source brings in the most value?
14
10
please select example cases of loans that are not of type CAR and were issued in January. how many such cases are there?
15
11
what is the average issuance time (from application creation to issuance) monthly by agent? by team?
16
12
what is the average time between the first status change and loan issuance monthly?
17
13
how many active loans are there daily?
18
19
20
Have you noticed anything else in the data that you'd like to share?
21
Please create a few visualisations to highlight what you believe are the most important things.
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100