Timi the analyst
@analyze_timi
Followers
7
Following
28
Media
18
Statuses
34
Joined June 2025
0
0
1
No 3 Approach: from the innotransfer transaction table .Selected channel , used the avg function .Then used the where function to specify the output of completed transaction .Then group by channel to get each channel average .Then I order by avg “desc” to get the highest
0
0
0
Then multiplied “the payment_failed cte “by 100 and divided it by “total transaction cte “to get the failure rate percentage.
1
0
0
No 2 Approach: from the innotransfer data .Selected count to know the total transaction the created a “total transaction cte”.Then again from the innotransfer payment table selected count failed transaction by using where to specify then created a “payment failed cte”
2
0
0
No 1 Approach:from the innotransfer table selected the channel and used the count function to count total number of transactions then grouped by channel to get the total.Transaction per channel
1
0
0
Day 23 of 30 Days of #SQLwithFunmi .Questions.1 What is the *total number.of transactions* per channel?.2.What is the *failure rate*.of each payment channel?.3.Which channel has the.*highest average transaction value* (A) for completed.
0
0
0
Then created a subquery and used the count function to count the total users that were both receiver and senders.
0
0
0
No3 approach: from the innotransfer data .Selected the sender id .And used the where sender id is not null to filter out null set and used inner join to join the receiver id that I selected from the innotransfer where receiver id is not null
1
0
0
and use the count function to get total transaction .And grouped by user to to get each how many times each user used and order by desc.
0
0
0
No 2 My Approach:From the innotransfer data .Selected the sender id and named it as users .I also selected the receiver id from innotransferdata then named it as users then “Union all “ them and created a subquery after which I selected from the subquery the user
2
0
0
and use the count function to get total transaction .And grouped by user to to get each how many times each user used and order by desc
1
0
0
Day 22 of 30 Days of #SQLwithFunmi.Question . 1 Find the *average number of transactions per active user*. 2 Identify the *top 5 most active users* by number of total transactions (sent + received ).3. How many users have acted as *both sender and receiver*?.
1
0
0
No 3Approach: from the innotransfer data set selected the payment mode and used the count function to count how many times the channels were used and used the group by function to determine how many times each channel was used then order by desc to get the most transfer channel
0
0
0
No 2 approach: from the innotransfer data set used the select function to select the sender_id and used the sum function to get total amount then grouped by the sender_id to get total amount made by each sender then used the order by and desc function to get the highest
0
0
0
No 1 approach from the innotransfer set selected the sum function to get the total amount of money transferred on the platform
0
0
0
Day 20 of 30 Days of #SQLwithFunmi .#DataAnalytics. Today we dive into another data set of innotransfer.1 What is the total amount.of money transferred on the platform?.2 Identify the top 5.senders by total amount sent.3 Determine the most.frequently used payment channel.
3
0
0
No 3 Approach:from the payment data .Selected payment mode and used sum function to get total payment then group by payment mode to get the amount of each payment mode
0
0
0
No2Approach: from.The payment data .Selects the customer id , customer name sum the payment amount, I then used the the group by function to get arrive at how much each customer spent then used the “order by function to desc”to rank them
1
0
0
No 1Approach: from the payment data.Use the select function and used the sum () function to get total sales of the data and rounded it to 2 decimal.Places with the round function
0
0
0