SQL Intermediate Certification Skills Test on Hackerrank Detailed SOLUTION!
ฝัง
- เผยแพร่เมื่อ 8 ก.ค. 2024
- In this video I am solving the intermediate Certification Skills Test on Hackerrank. Watch also my other videos for more SQL Certification Solutions.
____________________________________________
SUBSCRIBE!
Do you want to understand how to solve SQL Problems in every detail? That's what my channel is about. When I was younger I thought I could never program because it looked way too difficult. The truth is that it takes time but with some patience anybody can do it! Follow me along and get better!
____________________________________________
SUPPORT MY CHANNEL
🙌The best way to support my channel right now is to give me a Super Thanks. You can do that by clicking thanks next to the title of the video. It is much appreciated!
____________________________________________
💾GitHub: github.com/CuriosityLeonardo?...
✋Add me on LinkedIn to get in contact: / markus-friemann-221b3814b
____________________________________________
Timestamps:
0:00 Sample test
1:50 First Question - Product Without Sales
6:34 Second Question - Business Expansion
Really bro..your coding style is just awesome
Thanks! I hope it helps 👍😊
Hey thanks for sharing. Great to see variant of solution and your thought process!
I tried to concat the user_account_id and the customer_id in the subquery and then count distinct them in the outer query to find the number of contact. Sadly it doesnt turn up as i'm intended. Perhaps do you know the reasoning behind this on why i fail?
Thanks a lot for the walk-through. Now there is another SQL (Advanced) certification available. Could you please do a similar video on that one?
Hi Steven, great suggestion! I have some other plans now but it is definitely on my list of videos!
Hi
learning a lot from your videos
could you please make a video for what approaches we need to follow while solving a medium level and advance level sql query ?
Hi Saurabh, thanks for the request, I will think of it if I can make something useful
Thank you for your video, It's helpful for me. Could I have a database to practice? Thanks.
Thank you so much
Loved it... Can u do it in MySQL server... Please
As part of business expansion efforts at a company, your help is needed to find all pairs of customers and agents who have been in contact more than once. For each such pair, display the userid first name and last name and the customer id, name and the number of their contacts. order the result by user id ascending.
Is that a question on the intermediate certification test?
why we need a with seciton ,what is stopped us to use ( where function) in first section
ty
Thanks so much
You're welcome!
Why is the invoice_id null?
Whats the content of set nocount on?
Hi Smart Trick, this prevents some analysis (counting) of the computer so that the query runs faster. It has no effects to the content of your code. For more details, see this link: stackoverflow.com/questions/38145270/what-is-the-advantage-of-using-set-nocount-on-in-stored-procedures-which-are#:~:text=SET%20NOCOUNT%20ON%20is%20a,showing%20the%20affected%20rows%20message.
Hey its so nice mr mentor, but i wonder a thing that how can you fix while writing automatically ? Its a extension? :D i realized it 3.09 form to from ? : D
Hi Kaan, no its not an extension. I just cut out a part of the video, thats why it looks so fast :D
is it shareable on linkedin?
Hi Rahul, Yes! It is shareable on Facebook, Twitter and LinkedIn. I shared the Certification in my LinkedIn profile which you can see here for reference: www.linkedin.com/in/markus-friemann-221b3814b/
@@thecodingmentor7701 👍👍
A department store maintains data on customers, products, and purchase records in three tables: CUSTOMER, PRODUCT, and PURCHASE. The store manager wants to know which product is on maximum discount for each category. Write a query to print the following fields for each category, ordered by category, ascending: category, product ID and discount for the product that has the maximum discount in the category. In the case of multiple products having same maximum discount within a category, print the product with minimum product_id.
You have anyone who can explain
algorithms like this?
What do you mean if I have anyone? Should I give you someone? How would this transaction look like?
that sample test is not indicative of the difficulty of the real test questions
What do you mean? The video is presenting a real test question, im doing a live certification in the video
@@thecodingmentor7701 I'm just saying the sample given by HackerRank isn't as hard as the actual test.
Help me out with this question
A department store maintains data on customers, products, and purchase records in three tables: CUSTOMER, PRODUCT, and PURCHASE. The store manager wants to know which product is on maximum discount for each category. Write a query to print the following fields for each category, ordered by category, ascending: category, product ID and discount for the product that has the maximum discount in the category. In the case of multiple products having same maximum discount within a category, print the product with minimum product_id.
Thanks for ur question Nasir. Unfortunately this is not the right place to answer this. Try to ask it on a forum to receive some help!
Where I can contact you directly
y r u doing this!! this is a goddamn test huh???
Yes, it is a SQL intermediate skills test