Arama Sonuçları: "#SQLwithFunmi"

15 sonuç
Timi the analyst
Timi the analyst@analyze_timi·
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
English
0
0
0
3
Timi the analyst
Timi the analyst@analyze_timi·
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*?
English
1
0
0
10
Timi the analyst
Timi the analyst@analyze_timi·
Day 20 of 30 Days of #SQLwithFunmi 1 Calculate the total revenue generated* from all sales. 2 Identify the top 5 customers based on their total payment amount. 3. Show the total revenue contributed by each payment mode
English
2
0
0
1
Timi the analyst
Timi the analyst@analyze_timi·
Day 19 of 30 Days of #SQLwithFunmi Questions 1Find customers who have made *5 or more purchases*. 2 List customers who have only used one payment mode in all their transactions. 3 Show customers whose total spend is above N50,000 but have never used POS.
English
2
0
0
3
Timi the analyst
Timi the analyst@analyze_timi·
Day 18 of 30 Days of #SQLwithFunmi 1 Approach: selected from the full sales payment data then selected the product name and use count function to get total product sold then grouped by the product name then used the having , and functions to get the. Result
English
2
0
0
2
TheCruiseBoi
TheCruiseBoi@MightyAbdboss·
Day 10 of #SQLwithFunmi! 🔷 Mastered logical reasoning with SQL. Retrieved corps members based on complex conditions like age range, preferred state vs. origin state, and missing contact details. Discovered the importance of using IS NULL for missing values. 💻 #30DaysOfSQL #SQLS
TheCruiseBoi tweet mediaTheCruiseBoi tweet mediaTheCruiseBoi tweet mediaTheCruiseBoi tweet media
English
1
3
7
229
TheCruiseBoi
TheCruiseBoi@MightyAbdboss·
🔷Day 9 of #SQLwithFunmi: I harnessed LIKE, IN, and BETWEEN to filter data with ease. Retrieved corps members by email, state, age, and name patterns. LIKE with wildcards (%) and IN for multiple values were total lifesavers! Now, querying data feels like a breeze! #30DaysOfSQL
TheCruiseBoi tweet mediaTheCruiseBoi tweet mediaTheCruiseBoi tweet mediaTheCruiseBoi tweet media
English
0
1
7
187
TheCruiseBoi
TheCruiseBoi@MightyAbdboss·
Catching up on Day 7 of #SQLwithFunmi! 🔷 Mastered aggregation with MIN, MAX, COUNT, GROUP BY, and ORDER BY. Found youngest/oldest corps members and counted members by institution state. Powerful techniques for data analysis! 💻 #30DaysOfSQL #SQLSkills #DataAnalytics
TheCruiseBoi tweet mediaTheCruiseBoi tweet mediaTheCruiseBoi tweet media
English
1
2
2
134
TheCruiseBoi
TheCruiseBoi@MightyAbdboss·
DAY 3 Report! Day 3 of 30days 🔷 Mastered SELECT with LIKE & wildcard (%) for filtering. Successfully queried emails containing 'tran', names starting with 'A', and phone numbers starting with '080'. Leveled up my SQL skills! 💻 See ya tomorrow!❤️ #SQLwithFunmi #30DaysOfSQL
TheCruiseBoi tweet mediaTheCruiseBoi tweet mediaTheCruiseBoi tweet media
TheCruiseBoi@MightyAbdboss

Day 2 Report – 30-Day SQL Challenge: Completed Basic SELECT Queries! 📌 Mastered extracting specific info, filtering records, and removing duplicates. Consistency is key! 💪 Keep practicing, Let's keep learning together! 🚀 #SQLwithfunmi #SQLChallenge #LearnSQLTogether

English
0
0
0
91
TheCruiseBoi
TheCruiseBoi@MightyAbdboss·
Day 2 Report – 30-Day SQL Challenge: Completed Basic SELECT Queries! 📌 Mastered extracting specific info, filtering records, and removing duplicates. Consistency is key! 💪 Keep practicing, Let's keep learning together! 🚀 #SQLwithfunmi #SQLChallenge #LearnSQLTogether
TheCruiseBoi tweet mediaTheCruiseBoi tweet mediaTheCruiseBoi tweet mediaTheCruiseBoi tweet media
TheCruiseBoi@MightyAbdboss

💡Ecited to share that I've joined a 30-day SQL challenge #SQLWithFunmi Although I missed Day 1 & 2 due to neps, I'm not letting that slow me down. I'm diving straight into Day 2 challenge today and planning to catch up quickly. Will give daily report here on X and LinkedIn.💻

English
1
1
3
311
TheCruiseBoi
TheCruiseBoi@MightyAbdboss·
💡Ecited to share that I've joined a 30-day SQL challenge #SQLWithFunmi Although I missed Day 1 & 2 due to neps, I'm not letting that slow me down. I'm diving straight into Day 2 challenge today and planning to catch up quickly. Will give daily report here on X and LinkedIn.💻
English
1
0
4
374