Pentazocine
@joules_01
Followers
756
Following
24K
Statuses
8K
An intending health practitioner | Data Analyst with Python ๐ and Power BI๐ | About learning Excel and SQL | Definitely going to learn #Flutter
Lagos, Nigeria
Joined July 2019
Habakkuk 2:2 And the LORD answered me, and said, Write the vision, and make it plain upon tables, that he may run that readeth it.
1
2
17
Day 21 of #Joules100daysofSQL. Moving on, I learned about the use of the SELECT subquery. I also combined the use of LEFT JOIN in a SELECT subquery.
Day 20 of #Joules100daysofSQL. Moving in from the use of the WHERE clause in subqueries, I learned more on the use of FROM statements. This can be used to create an additional column in the table. It also has more filtering capacity than the WHERE clause.
0
0
1
Day 20 of #Joules100daysofSQL. Moving in from the use of the WHERE clause in subqueries, I learned more on the use of FROM statements. This can be used to create an additional column in the table. It also has more filtering capacity than the WHERE clause.
Day 19 of #Joules100daysofSQL. ๐ฅ In today's lesson, I explored the use of SUBQUERIES in data manipulation. I used the subquery in the WHERE statement.
0
0
4
RT @YCDevotion: One of our amazing member @TheDivineSpeaks shares what she learnt during our morning devotion sessions. Join us on our Twiโฆ
0
5
0
RT @PsrcUnilorin: ๐ ๐ฒ๐ฒ๐ ๐ผ๐ป๐ฒ ๐ผ๐ณ ๐๐ต๐ฒ ๐ฃ๐ฟ๐ถ๐ป๐ฐ๐ถ๐ฝ๐ฎ๐น ๐ข๐ณ๐ณ๐ถ๐ฐ๐ฒ๐ฟ ๐ผ๐ณ ๐๐ต๐ฒ ๐ฃ๐ฆ๐ฅ๐'๐ 2024/2025 ๐ฃ๐ฎ๐ฟ๐น๐ถ๐ฎ๐บ๐ฒ๐ป๐๐ฎ๐ฟ๐ ๐๐ฒ๐ฎ๐ฟ: Name: Muhammed Abdulmutiu Onimisi Role:โฆ
0
4
0
Day 19 of #Joules100daysofSQL. ๐ฅ In today's lesson, I explored the use of SUBQUERIES in data manipulation. I used the subquery in the WHERE statement.
Day 18 of #Joules100daysofSQL. ๐ฅ Still learning about CASE functions, I used it with aggregate functions like SUM, AVG and COUNT. This can help us derive insights from the data.
0
1
8
Day 18 of #Joules100daysofSQL. ๐ฅ Still learning about CASE functions, I used it with aggregate functions like SUM, AVG and COUNT. This can help us derive insights from the data.
Day 17 of #Joules100daysofSQL. ๐ฅ Today, I explored complex use of 'CASE'. I combined the use of multiple requirements using 'AND' and 'OR' statements.
0
2
10
RT @SpiricocoNg: You probably know the person wearing grey addressing the people in this picture. That is Evangelist Mex, the pastor of tโฆ
0
675
0
Day 17 of #Joules100daysofSQL. ๐ฅ Today, I explored complex use of 'CASE'. I combined the use of multiple requirements using 'AND' and 'OR' statements.
Day 16 of #Joules100daysofSQL. Now, I'm learning about data manipulation in SQL. SQL makes use of the CASE statements which is similar to the if, else statement in python. SQL, under the case statements makes use of WHEN, ELSE, END and then aliases the result as a new column.
0
1
2
RT @Anikeje_2: The NAPA World Cancer Day symposium themed United against cancer: pharmacists as innovators and advocates was an eye-openingโฆ
0
1
0
RT @Hardesboy: Shalina Young Talent Award for the best Pharmacy brain in Nigeria. Here is the 2nd best pharmacy brain in 2025. His name isโฆ
0
8
0
RT @thecharlesdom: 100 ARTICLES IN 100 WEEKS ๐ฅ Article 44/100: Fear: The Silent Crippler In the quiet theatre of the human soul, fear ofโฆ
0
3
0