Thank you🤩, kindly suggest more videos you will love to see

@@aashu90 hello please, it’s working really well, can I know the error you are getting? And by the way the full explanation is here kzfaq.info/get/bejne/ga15fNl0tpamqGw.htmlsi=H56nPgtXRKO73cdh

@@oladijioluwakayode thank you 🤩

@@abrahamtakyi9557 the pleasure is mine

@@abrahamtakyi9557 noted! My email is [email protected]

@@limitless003 thank you

the pleasure is mine, thanks for the feedback

I am glad to hear that, thank you

I think the idea is to play around the question, you question is just testing your where clause and wildcard understanding, you can try where of about two cities present in the data. Regarding address, you can also pay around every col you think should form your address and concat them respectively. I hope this helps

@@OmolaraFash ok. i will check through again, kindly check the answer for this : -- Q23: Count the number of addresses in each country. select country, count(*) AS no_of_address from addresses group by COUNTRY order by COUNTRY asc;

Is the code right?

@@olatunjioladayo7126 yes please

@@OmolaraFash thanks. I will be asking you much questions. Thanks for all you are doing

Thanks, please give more details on the issue so I can help, do you mean you are not able to download from my GitHub or you are not able to upload to your workbench?

@@OmolaraFash am able to download. But once I download. I have problem in connecting with my sql workbench. Been on it , for past one hours. Can you help. Please. I can create a zoom link . Just 5minutes of your time

@@OmolaraFash I was able to download it. but to get it to mySQL workbench is issues. can you give me 2 minutes of your time to get it done with you.

This is such a great suggestions which are well appreciated, thanks, I will work on these vidoes

@@SinergiasHolisticas thanks 🤩

@@SS-hz4jo thank you 🙏

@@sushankkadayat5013 thank you 🥳

@@sushankkadayat5013 thanks for your comment, get ready for another exciting learning

@@cayspruceway yes please, you can check the data questions to solve more problems, it’s a pure SQL portfolio project

Glad to hear that!

Thank you 🎉

oh wow, thank you for your comment🙏

sure

Thank you 🎉

@@OmolaraFash Please why did you use the left join instead of the other joins.

@@theophilusdarko5820 product table was the master table that I need my record, the saleorderitem is like a transactional table, in this case, both left join and inner join should work similarly, because we do not have a duplicate id, so table product is my Master data which I need all my data and the primary key, so I did a left join on the transaction data, which has like the foreign key, I need to return all data in Product table even if there are no matches in saleorderitem, I hope this helps

Good point, with or without the group by, the query works fine, except we have duplicate ID

@@OmolaraFash sorry, I am new to SQL, at my earlier stage of data analytics journey and just learning from KZfaq source and some other free resources. You are absolutely right, if you are querying on the transaction table, the product id and the products would have more than record (duplicates) where by grouping would give us distinct or unique records. Thank u for the positive feedback. I was misled by being introduced to the group by clause almost always to answer aggregations related questions!

Thanks, I will upload as soon as possible

My pleasure 😊

@@adebimpeolabisi7941it’s my pleasure

Glad to hear that

My pleasure!!

Thanks dearie

Coming very soon

Glad to know you got value, you can check the CTE part again, I could do a video on CTE's only, it's always confusing at first but am sure the more you keep doing it, the better you become

You are in the right place, I will be addressing this in my next post, God willing, please watch out for it

@@OmolaraFash God will give u the strength to do this.. looking up to you as my mentor towards my data analysis career. Please I watch one of your videos where you said we should volunteer for Jobs if we want to improve on our cv. I did volunteer to run the data analysis of oyo state camp for my NYSC batch February 2024 and my state code was included and sent to abuja. Please I want to ask what is your best advice on the way to put this on my CV

sure

Thank you 🤩

Thank you 🧎‍♀️

Hello 👋

We cannot wait to have you, yes it is possible to get Jobs, although the language is one thing, you might need to learn the language

Hello, thanks for subscribing, first I would say no skill is a waste, although here in Finland, language is a big barrier, but that shouldn’t stop you, I will encourage you to keep applying for jobs while you also try to learn the skills also, however, the best route to move to Finland is through studies, I hope your dream becomes a reality soon🤗

Thank you for your comment, your concern is well noted, I hope to do better next time

thanks for your comment, general application is Jan 3- 17th, result comes out in March and resumption is September, so you might need to wait till Jan 2025, you can refer to this link for more information and preparation of necessary documents, studyinfo.fi

By God’s grace, I hope so too, thanks for joining this community🤗

Thanks for pointing that out, I explained later that me as a student in Joensuu was able to use to card in Helsinki cafe

Hello, please reach out to me at [email protected], I will share my contact from there, then we can fix a place to meet🤗

Please reach me @[email protected]

Oh wow, I hope you desire comes through on day and very soon❤, but it’s extremely cold and difficult to step out here 😊

Yes yes, it’s heavy snow this season