Julia Manfredini

The summary of it all. When I first laid my hands on SQL I was skeptical about it. My mind was playing game 🎮 on me due to the query and code I will have to write ✍️ to get answer. I took it one at a time,not by bit, hoping it will go down well. The sweetest part is that you can't cheat your way to the answer,the steps must be followed. You can't use the Delete function when you are supposed to use the SELECT function to retrieve information from the database . The important aspect is for you to know the bases and the complex part of it will become more understandable. Am still learning and I will keep learning because learning is not just a process but part of the principles I'm becoming better ☺️. What tools and skills are you learning now??? keep pushing it, 💪 giving up is not an option. #Dataanalytics #SQL #Process

13

4 Comments

This is so great, initiative and effort are so powerful.

1

Can you tell why this SQL script will not run? SELECT      name,     -- Output 'Tall Female', 'Tall Male', or 'Other'     CASE WHEN height >= 175 AND gender = 'F' THEN 'Tall Female'     CASE WHEN height >= 190 AND gender = 'M' THEN 'Tall Male'     ELSE 'Other' END AS segment FROM athletes; I'll leave the correct syntax for case statements in the comments as a hint.

17

16 Comments

🚀 Day 7: SQL Aggregate Functions - COUNT, SUM, AVG, MAX, MIN 📊 Welcome to Day 7 of our 30-day SQL journey! Today, we're diving into SQL aggregate functions, which are essential for summarizing and analyzing data. 📚 Why Is This Important? Aggregate functions are powerful tools for summarizing large datasets, allowing you to derive meaningful insights. Stay tuned for tomorrow’s post: "Grouping Data with SQL: GROUP BY and HAVING Clauses." If you find this post helpful, please Like and Share it with your network. Your support keeps me motivated to continue sharing valuable content. Thank you! 🙌 #SQL #DataAnalytics #DataScience #LearningJourney #LinkedInLearning Shashank Singh 🇮🇳 Aditya Sharma Rishabh Mishra Munna Das Chandeep Chhabra Ankit Bansal Shail Sahu Shakra Shamim Akash Kamerkar

31

4 Comments