I'm a beginner and found these videos amazing. Everything is just what you need, no frills, no lengthy talking, right to the point, If I can follow, everybody can. Real examples of how to solve queries, proper use of screen space, with a strong support from his blog where you can delve into more if still hungry of it. All for free, I so much appreciate this work, first class.
@techTFQ2 жыл бұрын
This feedback made my day.. thank you Stefano 🙏🏼 Your feedback is so precise that I feel I am able to deliver what I wished to deliver.. Thanks again and I am so happy you are able to follow this video 🙏🏼☺️
@rahulganga3274 Жыл бұрын
You are beginner and you need short and real examples >> How examples in shorts ? Don't Lecture If you Don't Have Common sense.. He is doing Perfect..
@IndianHacker-hisBest11 ай бұрын
You are awesome Taufiq bro @@techTFQ
@sudhap15552 жыл бұрын
Thank You so much techTFQ. Your videos are sooo soo good. After learning window function by myself, the concept wasnt clear for me. It was after watching your video on window function I got a idea of how it works. Last month I had interview and questions were from SQL only. They asked different queries based on window functions and joins. The result came within a week and I am joining the company as Research Executive.
@techTFQ2 жыл бұрын
Amazing to hear this Sudha 👌 Thank you for sharing your success story.. I am really happy to have contributed to your learning .. Wishing you all the very best with your new job 💐
@manojpatil24572 жыл бұрын
Kudos
@deepakts89412 жыл бұрын
Sir I saw all the sql videos it was really helpful. You are one of the best faculty and make concepts understand so easily.
@techTFQ2 жыл бұрын
Thank you so much Deepak 🙏🏼 Am so glad you have liked my videos 🙂 And thank you for taking time to leave your feedback 🙏🏼
@nareshsachin7967 Жыл бұрын
I have to mention the mistake from your blog. You gave a solution query In your official blog. Problem NO. 10 you write a query for fetch all female count and male count with out removing duplicate records. So it return more number of users rather then the actual user count. Please verify all queries once. Your tutorial is very helpful thank you lot.❤
@enriquembomio36862 жыл бұрын
You made my day and that of many others’ learning SQL by sharing this amazing video! Please keep posting such valuable materials 👍
@techTFQ2 жыл бұрын
Thank you Enrique 🙏🏼 Am so glad to hear you benefited from this video 🙂
@laurak51962 жыл бұрын
TFQ, it’s like you were reading my mind! This is exactly where I’ve been stuck, not only finding reliable datasets that are interesting, but not knowing how to properly load them into Postgres so I can play. I really want to thank you so much for your time and efforts. I’ve only seen your intro, but you can bet I’ll be returning to see how you’re importing this dataset and connecting it to Postgres. It seems like that would be an easy thing to do, but I’ve tried and it isn’t. You will be helping so many people with this video. And your explanations are better than most instructors I’ve seen. You have many talents, but you’re an excellent teacher. Thank you again, so glad I found you here on KZfaq! 🙏🏻😀
@techTFQ2 жыл бұрын
Hi Laura , Thank you for such an amazing feedback🙏🏼 Taking your time to appreciate my work, I feel so happy to read each n every word you said. Am so glad you have liked my content and I am able to help you with your learning ☺️.. Thanks again 🙏🏼
@laurak51962 жыл бұрын
@@techTFQ If I am able to make a career change as I hope to, it will be in no small part due to your efforts. I’m very grateful for your expertise and your ability to explain tricky concepts and break them down easily for us. Not everyone can do this; you have a gift 🙏🏻!
@laurak51962 жыл бұрын
@@techTFQ PS I’m also going to try and solve all of your questions and I’ll be visiting your blog for more on that. Hopefully I won’t need any of your hints but still being new to SQL, I’m not so sure on this. All the time and effort you put into this is really appreciated. I hope next year at this time you have over 100K subscribers because you deserve it!
@techTFQ2 жыл бұрын
That’s a very big complement Laura .. You’ve made my day by such kind words.. I truly wish you get your dream job .. thank you once again 🙏🏼
@techTFQ2 жыл бұрын
Wowww amazing.. 100k would be great.. I’ll remember this comment if that happens by next year 😃 And yes try out solving all the queries .. after that hopefully you can come up with some queries of your own.. good luck 👍
@kswinny3654 ай бұрын
I cannot overstate how helpful this was. I was at my wit's end trying to figure out how to resolve the rogue ' without editing the source file. Thank you!
@ckarkhan6 ай бұрын
Thoufiq, I've been writing SQL for many years now but watching these and other videos by you takes me to a different level. What I've learned is to break the problem into smaller parts and solve them individually. Also, there is a huge boost in my confidence in SQL interviews and the elevated quality of my code is noticed by the interviewers. All this is thanks to you. If I may request something, please make some videos on use of the QUALIFY clause in window functions. Also a video on the use of CUBE and ROLLUP features would be awesome! Is that asking for too much? Now, although I can read up on all these topics, if I watch your video, I will be able to internalize it even better. You are the best. Keep it up!
@bharathkumar.m95422 жыл бұрын
You're the best man..main part is you explain how to write queries by dividing the question and even the format part you follow..excellent quality. Thanks for guiding so many of us through your valuable content ❤️🙏..it would be great if you do more videos of query optimization and tuning in stored procedures your way of teaching would make it simple to understand them.
@PiyushBhisekar Жыл бұрын
How do you explain everything so effortlessly! Best SQL resource on the internet!
@swatisinha32302 жыл бұрын
It feels like whatever I am looking for now a days I can find it here. Thankyou so much for this video 🙏🏻
@techTFQ2 жыл бұрын
Your welcome Swati 🙏🏼
@iitian20122 жыл бұрын
Your sql query brings lots of clarification to the approach of solving. It would e of great help if you could take a step more further considering the real time scenarios where we have large number of tables inter related and we have to write queries out of those table. The main issue we face in such cases is the approach to join the certain set of tables and in using the window functions as well.If you can guide for such cases.
@techTFQ2 жыл бұрын
Thank you Aditya 🙏🏼 Prior to this video, I had already posted another video where I covered solving complex SQL queries where I used window functions and JOINS.. perhaps you can check that video out.. link below: kzfaq.info/get/bejne/fLSJl6V93MCak3k.html
@sachinjagtap3220 Жыл бұрын
Your videos are actually giving me practical training on sql , very well explained with logics and prgani
@jeevankumarthadikonda7151 Жыл бұрын
The last query explanation was just mind-blowing the best part of your explanation is dividing the problem into small parts and solving it step by step
@aapbeete9761 Жыл бұрын
You made the first query very complicated. The simple solution is as follows: SELECT Sport FROM olympics_history GROUP BY Sport HAVING COUNT(DISTINCT Year) = (SELECT COUNT(DISTINCT Year) FROM olympics_history where Season='Summer');
@gilbertpradier11 ай бұрын
Simple and elegant
@vishalsonawane.89052 жыл бұрын
Hello God Gifted sir👑, I think you is one of the KZfaqrs for best content to teaching SQL Your video is really amazing and we alll students shares your all videos to our college and teachers also refer your video.... Please keep it up sir and make more videos for related SQL.... please please ..
@tushardaund3836 Жыл бұрын
You are such an inspiration . the way you are helping me understand clearly what want is just amazing. Your efforts are seen and appreciated as well. i tried to solve question no 5 in my way please look once with cte as ( select games , noc from OLYMPICS_HISTORY group by games ,noc ) select noc ,count( noc) from cte group by noc having count(noc)=(select count( distinct games) from OLYMPICS_HISTORY ); ;
@sheebaparveen36302 жыл бұрын
You are such an inspiration and my role model . the way you are helping everyone understand clearly what they want is just amazing. Your efforts are seen and appreciated as well. Seriously so so so proud ❤️
@techTFQ2 жыл бұрын
Thank you Cheeb for the support always :) Happy to receive your feedback 😍
@fudgiplantaud2108 Жыл бұрын
@@techTFQ how did you find the script to run on the database
@shaikusman5362 жыл бұрын
WOW...(7,611) views, (402) likes 0 (Dislike) achived in 16 days (28-10-21 to 13-11-21); thats Awsome appreciation for your knowledge and skills brother.....Thanks a ton....
@techTFQ2 жыл бұрын
Thank you Shaik :) I dint realize this like and dislike count until i saw this comment :) Glad this video is liked by so many.
@agrim88632 жыл бұрын
Thoufiq first of all the video is very insightful, and meticulous I reallly learnt a lot of new concepts hands down your tutorials on SQL are one of the I have ever come across. Please upload more such videos in future as well.
@techTFQ2 жыл бұрын
Thank you Agrim :) I am glad to know you have benefited from these videos :)
@minalgupta74562 жыл бұрын
yur are the best teacher of sql, I am a big fan of u
@techTFQ2 жыл бұрын
Thank you Minal :)
@hieutruong17692 жыл бұрын
I have learned so much from your series. Thank you so much sir !!
@techTFQ2 жыл бұрын
Thank you :) So glad to hear this..
@AhmerJamil2 жыл бұрын
You are doing Amazing job, keep on doing the good work!!
@techTFQ2 жыл бұрын
Thank you Jamil 🙏🏼 Glad you liked it..
@abdulsamadibrahim49292 жыл бұрын
Thank you so much TFQ! This goes a long way for me! Always learning new strategies to tackle SQL queries.👍🏻
@techTFQ2 жыл бұрын
Thank you Ibrahim 🙏
@karennguyen70832 жыл бұрын
I learned a lot from your SQL videos, please upload more videos about SQL and Python in the future. Thank you so much.
@techTFQ2 жыл бұрын
Thank you, will do!
@fathimafarahna26332 жыл бұрын
Proud of you mate...God bless all your efforts and time to give out authentic and precise content👌🏻👌🏻👌🏻🙏
@techTFQ2 жыл бұрын
Thank you 😘
@murchhanabanerjee8626 ай бұрын
@ Taufiq sir where is your vlog link ? Can't find it
@VsK3Bal Жыл бұрын
Your are the best! Thanks a lot for this class, now I know all the data sources and how to practice!
@girijashamak91422 жыл бұрын
Just came back to your channel. Very happy to see you with many more subscribers. More wishes young man. God bless 🙏
@techTFQ2 жыл бұрын
Thank you so much Girija :)
@sandeepbhonsle8118 Жыл бұрын
This has actually helped me a lot in understanding the SQL Thanks and keep posting such videos.
@shobhareddy41592 жыл бұрын
Yours are the best videos that I have ever found on you tube …. Keep going Toufiq
@techTFQ2 жыл бұрын
Glad you like them Shobha!
@zeeshanahmed2594 Жыл бұрын
Thank you very much Sir, for this tutorial. Got more clearity and new perspectives to approach a problem.
@manishgaurav842 жыл бұрын
Very nice set of questions. Query 3, at 26:12, If in interviews it is not allowed to use pivot functions then we can do it using CASE WHEN with medals as (select nr.region as country, (case when medal = 'Gold' then 1 else 0 end) as Gold, (case when medal = 'Silver' then 1 else 0 end) as Silver, (case when medal = 'Bronze' then 1 else 0 end) as Bronze from olympics_history oh join olympics_history_noc_regions nr on nr.noc = oh.noc where medal 'NA') select country, sum(medals.Gold) as gold, sum(medals.Silver) as silver, sum(medals.Bronze) as bronze from medals group by country order by gold desc, silver desc, bronze desc;
@manvendraprasad1848 Жыл бұрын
thanks, Manish i found this easy
@rushikesh33637 ай бұрын
You are right i think also check my answer plz with cta1 as (select country, count(*) as Gold from OLYMPICS_HISTORY oh join OLYMPICS_HISTORY_NOC_REGIONS nr on oh.noc=nr.noc WHERE medal='Gold' GROUP BY country) with cta2 as (select country, count(*) as Silver from OLYMPICS_HISTORY oh join OLYMPICS_HISTORY_NOC_REGIONS nr on oh.noc=nr.noc WHERE medal='Silver' GROUP BY country) with cta3 as (select country, count(*) as Bronze from OLYMPICS_HISTORY oh join OLYMPICS_HISTORY_NOC_REGIONS nr on oh.noc=nr.noc WHERE medal='Bronze' GROUP BY country) select country,gold,silver,bronze from cta1,cta2,cta3 where cta1.country=cta2.country and cta2.country=cta3.country;
@rushikesh33637 ай бұрын
also select nr.region as country, sum(case when medal = 'Gold' then 1 else 0 end) as Gold, sum(case when medal = 'Silver' then 1 else 0 end) as Silver, sum(case when medal = 'Bronze' then 1 else 0 end) as Bronze from olympics_history oh join olympics_history_noc_regions nr on nr.noc = oh.noc where medal 'NA'
@SSRKFJ2 жыл бұрын
Amazing...thanks a lot for sharing knowledge.. It means so much for learners lik me... Pls continue and post more content about sql for data analyst
@techTFQ2 жыл бұрын
Thank you Jayanth 🙏🏼 Glad to see your comment ☺️
@amitshrestha14562 жыл бұрын
Thank you so much. It's entertaining to watch and learn. This is the training video I've been looking for. I'm currently working with Oracle SQL Developer and can only insert partial data. It would be more fun if I could insert the entire data set.
@techTFQ2 жыл бұрын
Your welcome Amit 🙏🏼 I am glad you liked it.. Do you get any error when importing all the data ?
@amitshrestha14562 жыл бұрын
@@techTFQ Thank you for responding. I fixed it. I accidentally checked the limit box, which is why only partial data were inserted. Importing a dataset was a lot easier than I expected on SQL developers. There's no need to write the entire Create statement. Thank you for the video once more. Continue making videos and motivating us. Happy New Year!
@techTFQ2 жыл бұрын
Great to hear Amit 👌 Thank you and happy new year to you too 🎊🎉
@robertgatterai72692 жыл бұрын
Man! I’ve been looking for something like this, thanks man
@techTFQ2 жыл бұрын
No problem buddy! glad this helped
@msateeshkumar69022 жыл бұрын
You are like god ( teacher ) for me .🙏
@pragyan111142 жыл бұрын
great work .It is really very much helpful for beginners. Please do more videos for us.
@techTFQ2 жыл бұрын
Thank you and will do
@poojamahesh85942 жыл бұрын
really sir, u are doing a great job..please keep helping us!!!! really very very usefull
@techTFQ2 жыл бұрын
Thank you :) Glad you liked it Pooja
@lucianlackman8103 Жыл бұрын
This is the kind of video been looking for ages
@spbspb2413 Жыл бұрын
It indeed became quite complex by the end, but also very simple at the same time thanks to your reasoning
@tamilanveeran48642 жыл бұрын
Today subscribed your channel and really amazing explanation , I would recommend this video to my friends , thanks toufiq
@techTFQ2 жыл бұрын
Awesome buddy, glad you liked it
@alex45688 Жыл бұрын
God bless you brother, really loved your content so clear to the point, I am beginner concepts are getting clear , if you add more videos will learn and to become mastery in it
@preyashthakur71 Жыл бұрын
Hello sir, I have learned sql recently but didn't how to apply this skill and practice of the project , but your videos helped me to understand more about SQL and about the work of data analyst. I have a question ,can we show this project in LinkedIn ? if yes then how?
@moulyanerella6 ай бұрын
I want to solve some queries in SQL but I don't find anywhere correctly.Thanks for the video by letting this know.
@rishigupta23422 жыл бұрын
Thanks!!! Make more video like this for sql practice.Also could you make a EDA video for python? You explain things very nicely.
@techTFQ2 жыл бұрын
Thank you Rishi 🙏🏼 Yeah for EDA , I will plan to do it..
@amanahmed60572 жыл бұрын
Sir plz make a full-fledge course of 5-6 hours just like freecodecamp videos on SQL queries which covers from basic beginners to Advance Love from 21 yrs old boy congrats in Advance for 100k subs
@techTFQ2 жыл бұрын
Haha thanks Aman ☺️☺️ 100k is far away but thanks for the wishes 🤩 As for one long video, never thought about it but I’ll start considering it now
@technicalraman8848 Жыл бұрын
Sir Salute. Plz plz make case study on sql by taking different datasets and also do data cleaning using sql and use advanced sq; queries. Plz sir
@ATTI08222 жыл бұрын
Amazing video! I'm a frontend guy, watching your videos help me widen my skills in an excellent way. Thanks! I have a question regarding the performance. I don't know too much about the performance of the partition by statement. In the last task, the partition by was used several times in the concat fns (5-6 times). What do you think regarding the performance in a production ready environment? Would it scale well by the time if total number of records grow?
@techTFQ2 жыл бұрын
Hi, thank you 🙏🏼 Glad you find these videos useful.. As for performance, window functions are pretty good even if we use partition by.. they should not cause any performance bottlenecks but then it also depends on how you write your sql query. As for my query in this video, we had around 270k+ records and still the queries with multiple partition by hardly took a few milliseconds to run.. Even with much more data I believe this won’t cause any performance issues but again it all depends on how you write your sql queries and how you create indexes on your tables and few other factors like table statistics etc.
@ATTI08222 жыл бұрын
@@techTFQ thanks for the detailed answer 👍
@techTFQ2 жыл бұрын
Your welcome bro 🙏🏼
@mrrk69607 ай бұрын
Hello sir, I am your big fan, and your videos helps me alot, For that Jazakallahu Khaira, Sir in your blog there's a slight problem, the expected output you showed is wrong somewhere I think, some of that I noticed and you can check the 18th problems expected output. Thankyou sir
@ohme_ohmaya_2 жыл бұрын
Hi I've been watching your videos for a while and i love them. They're very helpful! But I wanted to let you know that I think there may be somehing wrong with your crosstab function (or maybe it's not reading the data correctly). For example, your response to question 18 shows that Paraguay has 17 bronze medals. They actually have 17 silver medals. I think the function my be classifying data into the wrong columns. I found that simply pivoting the medal data from rows to columns in MySQL did the trick! Just wanted to let you know. Have a great day!
@techTFQ2 жыл бұрын
Hi Maya , Thank you for liking my contents 🙏🏼 And thanks for highlighting this difference.. I am actually surprised,, I had tested it for a few countries data.. let me check this out tomorrow and correct it if needed.. Thanks again 🙏🏼
@ohme_ohmaya_2 жыл бұрын
@@techTFQ no problem!! You’ve helped me so much in developing my SQL skills. I really love and appreciate your videos! If you could do more of these types of videos where you display advanced SQL techniques using data on kaggle, that would be awesome. Thanks again and have a great day!
@techTFQ2 жыл бұрын
Am glad to hear this Maya.. Yes I plan to cover more such videos in the near future.. Have a good day to you too..🙂🙏🏼
@tonydominic-ll4wi Жыл бұрын
Bro your channel is Amazing I am officially a fan now 😀😀😀
@Ganeshay-9962 жыл бұрын
awesome👍👏👍👍👍👍👍👍👍👍👍👍
@techTFQ2 жыл бұрын
Thank you Ganesh :)
@shivsharma91532 жыл бұрын
thats what i call quality content
@techTFQ2 жыл бұрын
Thanks Shiv 🙏🏼
@shafi1232 жыл бұрын
Thank you so much Thoufiq. I learnt a lot from your channel
@techTFQ2 жыл бұрын
Your welcome Shaik 🙏🏼 Glad you liked it..
@mdnazmulahasanmirdha81423 ай бұрын
we need more video sir love from 🇲🇾
@user-xp3xd6pt3l Жыл бұрын
subscribed to your channel, please give us more real-world SQL projects
@amolberad48752 жыл бұрын
Great and Thanks!!! Make more video like this for sql practice.
@techTFQ2 жыл бұрын
Glad you liked it and sure will do
@gianglearning35092 жыл бұрын
Thanks. Hope you can release more videos like this in the future ^^
@techTFQ2 жыл бұрын
I plan to Giang
@realmusic96242 жыл бұрын
Your explanation is awasome AND plz make video on Root cause ANALYSIS
@techTFQ2 жыл бұрын
Thank you Mushtak 🙏🏼
@manishgaurav842 жыл бұрын
Similarly for Query 4, at 40:17, with medals as (select oh.games as games, nr.region as country, (case when medal = 'Gold' then 1 else 0 end) as Gold, (case when medal = 'Silver' then 1 else 0 end) as Silver, (case when medal = 'Bronze' then 1 else 0 end) as Bronze from olympics_history oh join olympics_history_noc_regions nr on nr.noc = oh.noc where medal 'NA'), county_wise as (select games, country, sum(medals.Gold) as gold, sum(medals.Silver) as silver, sum(medals.Bronze) as bronze from medals group by games, country order by games, gold desc, silver desc, bronze desc) select distinct(games), concat(first_value(country) over(partition by games order by gold desc), ' - ', first_value(gold) over(partition by games order by gold desc)) as Max_gold, concat(first_value(country) over(partition by games order by silver desc), ' - ', first_value(silver) over(partition by games order by silver desc)) as Max_silver, concat(first_value(country) over(partition by games order by bronze desc), ' - ', first_value(bronze) over(partition by games order by bronze desc)) as Max_bronze from county_wise order by games;
@subhabratanath20752 жыл бұрын
Hi brother your tutorials are the best.. can you please make a course alongwith problems so we can learn in-depth?
@techTFQ2 жыл бұрын
Thank you Subhabrata 🙏 and I will make a complete SQL tutorial in a couple of months time.
@karthickraja1026 Жыл бұрын
Trust me guys, this series have worth more than 'n'thousand price for those who want master in sql. -Thankyou so much for your effort @techTFQ💯
@anirvansen50242 жыл бұрын
Thank you so much for these question sets , I have just completed these questions sets , What do you recommend which type of questions should we do now ?
@apamwamba3 ай бұрын
Looks like 51 unique olympics games are in the database but 52 olympic games by location are listed because the 1956 were held in two cities.The 1956 Summer Olympics, officially known as the Games of the XVI Olympiad, were an international multi-sport event held in Melbourne, Victoria, Australia, from 22 November to 8 December 1956, with the exception of the equestrian events, which were held in Stockholm, Sweden, in June 1956.
@apamwamba3 ай бұрын
So you really need to undetstand the data as rightly advised!!
@ShubhashreeMunot Жыл бұрын
Hii Taufiq, Big fan, learner and admirer of your work here!! I'm one of the most benefitted person from your videos. I just wanted to inform, in query 12, as you have taken 'group by name and team' and because data is not so clean ...hence it has missed the name of athlete 'Birgit Fischer-Schmidt' from Germany who is among top 5 athletes by total number of medels won. her team is shown as 'Germay' as some places and 'East Germany ' at some places. you could have get even accurate results by grouping on id and name.
@pveeranjireddy89592 жыл бұрын
Thank you... thank you....for sharing and posting.to world
@techTFQ2 жыл бұрын
Your welcome bro 🙏🏼 Glad this helped
@suchitaachari66152 жыл бұрын
Thank you so much for this. I just have 1 doubt. In the question number 3, Can't we just use below query directly instead of with clause? Please do clarify my doubt. Select game,count(n.region) from history h join noc n on h.noc=n.noc group by game
@techTFQ2 жыл бұрын
You cannot because the output is wrong.. because history table has data for each athlete so there would be multiple athletes from each country corresponding to each olympic games so the counts would be way to more.. For example, in 1896 games, 12 countries participated but from your query you would get 380 (which is the total athletes and not country)
@suchitaachari66152 жыл бұрын
@@techTFQ Ahh Okay. Got it. Thank you 👏
@techTFQ2 жыл бұрын
Your welcome 🙏🏼
@test-hj9lx2 жыл бұрын
Very nice practicing videos
@techTFQ2 жыл бұрын
Thank you 🙏🏼
@1281dee2 жыл бұрын
Amazing video, Thank you. I started my learning journey with MySQL can I still use these codes on MySQL? Also can you share some projects for MySQL that I can practice with?
@Mysingh97672 жыл бұрын
Thanks for such a great videos....
@techTFQ2 жыл бұрын
Your welcome Dhananjai :) glad this helped..
@dimuthuathapaththu5406 Жыл бұрын
Really appreciate your work. ❤❤❤
@jonathanbuenyen46792 жыл бұрын
Thank you sir. How do I load this same datasets on mysql? Could you help ?
@hassy91182 жыл бұрын
Simply awesome!
@techTFQ2 жыл бұрын
Thank you so much :)
@pydjango98122 жыл бұрын
Great video sir
@techTFQ2 жыл бұрын
Thank you 🙏🏼
@tanmayvyavhare5863 Жыл бұрын
Can't we use the below query for problem number 3 instead. Although I appreciate the efforts you take to explain every small detail, I feel this could have been simplified using the below query. Select nr.region, Sum(case when medal = 'Gold' then 1 else 0 end) g_count, Sum(case when medal = 'Silver' then 1 else 0 end)s_count, Sum(case when medal = 'Bronze' then 1 else 0 end)b_count From olympics_history oh join Olympics_history_noc_regions nr On oh.noc = nr.noc Group by nr.region;
@NirdeshM2 жыл бұрын
thanks alot, very well explained
@techTFQ2 жыл бұрын
Glad it was helpful!
@TheDisciplinedPoser2 жыл бұрын
Hello, I'm a newly subscriber and I have been looking for channel like this for quite sometime. Thank you. For Query 2, I can just use limit 5 if ranking is not needed? select name, team, count(medal) as total_medals from olympics_history where medal = 'Gold' group by 1, 2 order by 3 desc limit 5
@techTFQ2 жыл бұрын
Thank you for liking my contents 🙏🏼 Limit 5 will just fetch the first 5 records but if you look at the data there can be multiple athletes who won 9 gold medals or 8 gold medals so you need to fetch all of them.. That is why ranking is required
@TheDisciplinedPoser2 жыл бұрын
@@techTFQ looking forward to seeing your solution to other queries
@honestreview69002 жыл бұрын
You are Great Dear
@techTFQ2 жыл бұрын
Thank you 🙏🏼 Glad you like the content 🙂
@Motivation_Station_Neo2 жыл бұрын
great explanation
@techTFQ2 жыл бұрын
Thank you 🙏🏼
@esperatbamgbose75698 ай бұрын
Thank you ,for this amazing tutorial
@techTFQ8 ай бұрын
Welcome:)
@theaj1990212 жыл бұрын
Great content !!!!
@techTFQ2 жыл бұрын
Thank you Amit
@Jennyluuuu2 ай бұрын
This project is incredible! I do have one question. I imported this dataset into mySQL and the data was not fully imported no matter how many times I tried. There were supposed to be 271k+ rows of data but I only got 270k something, which changed up the accuracy of my query results a little bit. Do you know how to fix this?
@analystgabriel2 жыл бұрын
Great video
@techTFQ2 жыл бұрын
thank you Gabriel :)
@gabrielfinco87682 жыл бұрын
Hi Very good tutorial abd very helpfull,i got a question, in a team sport like football how can we count the correct way since it counts by athlete, i mean 2016 Brasil won 1 Gold medal instead of 22 for football
@techTFQ2 жыл бұрын
Hi Gabriel, Thanks for liking the video 🙏🏼 I think, I already had a query for this exact question and the solution was to do the count by taking the DISTINCT Team value.. 22 players but the team is just 1 so when I do a distinct I get just 1 and not 22
@prash5162 жыл бұрын
Hi Taufiq...first of all, gratitude for the things I am learning with your great videos. Reg this activity, can you please help on what to do with the "Table_Structures.ddl" file? can we create a table directly with it rather than writing the "create table" query? Also could not find the query file for creating the table on your blog.
@techTFQ2 жыл бұрын
Thank you Prashanth 🙏🏼 Table_Structure.ddl is the file which has the create table scripts.. Just open this file in any editor and then copy paste the contents of this file into PG Admin to create the tables
@prash5162 жыл бұрын
@@techTFQ Got it. Thanks a lot for the kind reply. Hope to keep learning as much :)
@techTFQ2 жыл бұрын
Your welcome Prashant 🙏🏼
@mbhazimangoveni3068 Жыл бұрын
Man! I love your work
@daltonjaklitsch73042 жыл бұрын
On mysql workbench the csv file is taking such a long time to import .. the file is only 40mb so I don't understand why... any thoughts? I manually created a table and matched all the columns but it has been 30 minutes and I have 1k out of 130k rows
@dovlapav1614 Жыл бұрын
Same, probably it’s not compatible with MySQL😢
@ShivaniSingh-xj1ot10 ай бұрын
Hi I tried running the third query but the results were different even after I tried using ur solution. this was the question: 3. Mention the total no of nations who participated in each olympics game?
@kanelanecaiphus5951 Жыл бұрын
Earned my subscription 😎
@ELB_MohdShajar Жыл бұрын
Q6 query: select Sport, count(distinct(Games)) as count from athletes where season = 'summer' group by Sport having count= (select count(distinct(Games)) as count from athletes where season = 'summer')
One question is that Can we make pivot dynamic? If new medal i.e platinum is added then what will be query for that to make it dynamic?
@abdulsamadibrahim49292 жыл бұрын
Hi TFQ, please, how can one import .csv file to PostgreSQL automatically, most especially when one has a large dataset to work with. It's been giving me problem lately. Thanks a lot.
@minalgupta74562 жыл бұрын
pls upload more videos related to sql
@techTFQ2 жыл бұрын
noted, will do
@mayankbhardwaj14872 жыл бұрын
I am doing the same in MySQL but importing the csv to the table is taking too long
@techTFQ2 жыл бұрын
Is it.. I tried the same in oracle using SQL Developer tool and it was significantly slower compared to PostgreSQL.. Looks like importing csv file is the fastest in PostgreSQL
@divyasathish88534 ай бұрын
Thank you sir
@mahmoudsadiek9691 Жыл бұрын
1st query select count(distinct games) as co , sport from events where events.Season = 'summer' group by sport order by co
@mahmoudsadiek9691 Жыл бұрын
2nd query select top 5 count(medal) as "count medal" , name from events where events.medal ='gold' group by name order by "count medal" desc
@ManishKumarJha-uz9dl Жыл бұрын
Dear TechTFQ, I really liked your videos and I learnt a lot from you, but I'm stuck with PIVOT function in MS sql server "Write SQL query to display the total gold, silver and bronze medal won by each country in Olympics." can you help me with this.