Hi folks, csv files link (zip folder): 🔖Music Store zip csv files: shorturl.at/sEIUV If you are using Postgresql, Then directly import the database file .sql file. But if you're getting any error in album file then use the below query: CREATE TABLE public.album2 ( album_id int8 PRIMARY KEY, title character varying, artist_id int8 ); - refresh database (now u can see album table there) - Right click on the ablum table and select the Import/Export option Then select the album2.csv file (from your computer) The file will be imported successfully 👍🏻 Similarly, you can do it for other files. NOT USING POSTGRE SQL: 2. If using any other sql then, Use csv files n create your own music database. And for album file, first copy n paste in a new csv file in your computer n then import it to sql. It will work ✌️ Also, if you want help, pls watch my video on - How to import csv files in sql Keep learning and keep growing!🚀
after following the steps mentioned,and while creating the playlist_tracks, it says the error "can't create the table playlist_track, as multiple foreign keys are found" PLEASE HELP ME IN IT
@@RishabhMishraOfficial SIr please please write add to resume points in my reply ...your writing is so much professional please i wanna add this in resume
@@chakrabartisayantan4013 use chatgpt, prompt what u have done in your resume and ask gpt to write it like as u would write in resume/ short and crisp and highlighting everystep
you saved lakh of rupess , srlsy student dont understand that there is lots of free education on internet, they just have to gain and make some awesome projects but they prefer to spend lakhs of rupees , Thank You Sir For Your Efforts.
Learned a lot from your channel, I have completed this project with 3 days effort because I am a beginner. Please teach us more SQL-related real projects through your channel. Really Appreciate you, BOSS.
Hiii, I am interested in switching my current field to a Data Analyst job, I find your videos to be engaging, effortlessly comprehensible, and packed with valuable insights. I am watching your videos and practicing. thank you.
Sir how to add this in resume means what points I have to write please write jn details please it will hardly take your precious 5 minutes. I'm begging to you😢@@RishabhMishraOfficial
Hi Rishabh, I am writing this comment at the end of the video, this was my first Data Analytics Project and all I want to say is you're doing God's work out here. In the beginning I struggled a bit but as the video went by things became easier and I got the hang of it. Through the course of the video I got to learn new concepts of SQL as well as brush up my past knowledge of SQL. The video is very well structured and each question is explained very well, crisp and precise. Again, thanks a lot, I really appreciate your efforts, keep it up.
Congratulations, sir, on reaching 100K subscribers! This is a significant milestone and a testament to your hard work, dedication, and the valuable content you have been providing to us.
Hi brother.. Mera name krishna gopal hai Mai bhut dino se ek sahi mentor dhoond rha tha.. Finally i got you. Or maine thode din phle hi aapki.. Data analytics road map vali video dekhi. Or uska pdf download krke.. Excel se apna learning process start bhi kr diya hai.. Please hmesha hmaare sath bne rhna.. .. Thanks May god bless you bde bhai..
For those having issues importing the Database file.sql file, In PostgreSql, File -> preferences scroll down a bit paths -> binary paths For both server paths make sure your binary path is set: For instance EDB Advanced Server 16 I have set it to C:\Program Files\PostgreSQL\16\bin and then saved it Hope that helps!
Guys please share his channel and all videos he deserves million subscribers , your are awesome i mean i saw your video about data analyst roadmap , after i saw that video i thought there is no use to go to institute you have planned the roadmap very perfectly and it look like easy and amazing, and the videos step by step , middile class people can't affort institutes fees but you provide it all free from scratch thats amazing and its free of cost hats off to you bro lots of love and good wishes and one request please make video about data science also like roadmap and all the things you provide in data analysis provide in data science course also it will help me and all students guys share this video please he deserves millions subscribers 😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍
@@payaltanty6440 hi..are you using MySQL..cause I used that so ..if u are then all you need to do is check for some sort of errors that are in the file..like contents were missing..once done with that ..u are good to go ..let me know again if you still faced the issue ..I will gladly help and once more thing as far i remember in first file only few rows were missing..so check that thoroughly
Thank you, Rishabh Mishra bhai, for being an amazing instructor! I appreciate your guidance and support throughout the video. You're the true GOAT of data analyst!!! Bhai can you add English subtitle? Because some of your international viewers facing some difficulties like me. Best Wishes for your family & you. FROM BANGLADESH.
Nice video sir but if possible then please try to explain each query by writing live so that we can see the approach of you while dealing with complex and nested query. It will be very helpful for us.
Since I got interested in getting a Data Analyst job, I am binge-watching your videos and practicing. Your videos are very easygoing and rich in content. Requesting you to make an EDA project using python in the future. Thanks in advance.
I have done this project easy or moderate level boht achay smajh ay Advance level ka first question Thora tricky thay or i recommend k recursive say zada cte acha smajh aya finally i have done😊
Really good work Rishabh! I really appreciate the way you make things simple .It's really helpful for making projects and also understanding them instead of just copying.Thankyou so much!! Let your channel be reached to more people..!
Thank you so much for this awesome series.... Kindly make one series on python also......You are awesome work for people like us who wants to start from zero, a big thanks to you 🙏
Glad you liked it 👍 Also, tomorrow morning i m uploading a very important video for data science jobs that is forecasting. You can watch that as well and can include the skill in your resume
Thank you so much for the portfolio project. Your projects give me confidence that I can enter into data field without worrying about my non-cs background. I have a question here. How do we quantify or measure the insights that we derive out of this project. Any guidance will be very helpful. Thank you again!
Big thanks to you sir for your guidance and support throughout this project! 🙌 Your insights made a huge difference. Grateful for the learning experience! 🙏
Im mysql workbench I am able import all the table excep album.csv table It's showing unhandled exception: 'charmap' codec can't decode byte 0*81 in position 6012: character maps to check the log for details
Hi Sir, Thanks for this wonderful video. Can you share the summary of this project? what should i write on my resume regarding this project to get more interview calls? please help me out in this. I will a great help for me sir.
You are great and you have shared your experience it's very helpful for us and make some more such kind of video for SQL ,Python , as well as if possible plz make video on power BI
for those who are getting error in restoring the sql file. kindly do the following necessary changes in pgadmin 4 look for File>Preferences>Binary Paths> update the dir location to the C:\Program Files\postgreSQL\16\bin then save it then restore the SQL file.
Hi Rishabh. Firstly, thank you very much for this amazing project. A good way to start enhancing the SQL skills. Just one thing - I was practicing this project following your video, in the advanced level, question 1, do you think there is something missing/correction needed? like how much each customer spent on the top artist instead of how much each customer spent on the artists? Let me know if I am wrong.. Thanks again for this portfolio project. :)
The question is amount spent by each customer on artists, but the explanation seems to be the amount spent on top selling artist. Correct me If I am wrong. Thank u.
@@venkatashasidharreddychali7485 yes you are right i am trying the same both things are different . explaination is actually for the customers spent total amount on top selling artist where as question is for artists which means all artists . even i got confused
Thanks a lot for yours videos, these are really helpful to me or new aspirant to learn the data analytics. I had referred more than 5 friends till now, and I am watching your every single video.
Thanks Rishabh for such an amazing content. Your explainations are amazing. I have a problem in importing this database to mysql workbench. I am getting encoding error. I tried another way by first creating the database then created tables. But, when I started importing csv data files in mysql workbench using import wizard, it shows 0 rows imported. I tried using copy command that you mentioned in sql tutorial video, still no luck. How to import datacsv files into mysql workbench ?
You can't import postgresql dump files directly in mysql workbench. Either you have to re write the files because both have different syntaxes or you can import these files in postgresql. No other way! I had the same problem.
I have a doubt in (ADVANCE ques -1) the question says " amount spent by each customer on ARTISTS " but in the video in CTE you take LIMIT 1 which gives you the top artist only. why????
@@sarwarayaanali272 So did you get any solution to this?Should the question be different. I believe this must be the desired query for this question: select c.customer_id,c.first_name,c.last_name,at.name, sum(il.unit_price*il.quantity) as total_amt_spent from customer c join invoice i on c.customer_id=i.customer_id join invoice_line il on il.invoice_id=i.invoice_id join track t on t.track_id=il.track_id join album a on a.album_id=t.album_id join artist at on at.artist_id=a.artist_id group by 1,2,3,4 order by total_amt_spent Do let me know your thoughts on this. Thankyou so much. Awaiting response as I'm also scratching my head for last one hour.
Thank you for making these!! I'm following all of your videos :) I'm doing this project now and the advanced level is so hard.... but I'll keep practicing 🫡
Thanks a million Sir ......Must say you are helping to many Indians through your content! requesting please light on my below queries ! 1- I m working on MS SQL Server so just wanna to know is it good to extend my skills on it or should I move to MY SQL! 2- in real time how to refresh data from SQL data base to Power bi reports! 3- DO you have video on SQL data cleaning if yes then pls let me know the path!
Rishabh its very nice project, i learned so many thing from u, in future will learn too. Kindly make one vedio about Views,Indexes with project examples.
Thank you for the project and SQL . The database link is not working but I copied the data from csv to Postgresql and it works .It is matter of 8 tables to be copied so I think it is doable. Thanks for the insight
Thank you so mush for the content you provide us, I have watched some of your videos on SQL and excel despite I didn’t speak or understand Hindi I use the caption. I wish if you make the video in English so that a lot of people can benefit from your content. I appreciate your effort thank you
Tbh Rishabh bhaiya you are gem for our generation i enjoyed your video's it is help me a lot. Your video increase my confidence. Thankyou so much bhaiya for making such a amazing videos
Nice selection of database. Perfect for beginners to let go of their fear of multiple joins. Now only if someone could explain how is the group by clause not throwing error for when we don't include all other columns in it (except functions). I have used hive servers mainly and it does not allow having aggregate functions and other columns in select clause unless all other columns of select clause are also in group by clause.
hello rishab your way of teaching is very easy to understand and your usp mean Hindi language is really a good choice to distinct from crowd but i need one help just that i have mysql not Pg either please also provide database in mysql or teach us to install Pg
Thanks, Manish sir, actually, I didn't have any idea about CTE but now I have it. especially thanks and can you please make more videos of sql projects only not for powerbi projects.
You explained in good way ,i found in Advanced query section last 2 question u solved by using Recursion (2nd method) but actually its not recursion function u simply used 2 temp table .u not even using correct recursion syntax.see i might be wrong ,just observed and i thought i should inform here
Hi Rishabh sir..., I’m really interested in learning more about topic like TH-cam Analytics and SQL projects. Could you please make a video on topics like analyzing video performance, viewer demographics, and engagement metrics using SQL? It would be really helpful for my project! Thank you for your great content!..
12:30:33 select customer.customer_id, first_name,last_name,sum(invoice.total) as invoice_total from musical_database.customer join musical_database.invoice on customer.customer_id = invoice.customer_id group by customer.customer_id order by invoice_total desc limit 1.... Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column... plz look into this sir
Hi Rishabh sir, I'm so grateful that somehow I found your channel to learn data analysis concepts. With the help of this video, I have created my first data analysis project using SQL. Thank you so much for your efforts. Upon completion of this project, I was wondering whether data visualization of these same questions can be done using Excel or Power BI. And if yes, then please guide me through the process.
Thanks, Rishabh, for your valuable videos. Just one suggestion please, could you pls make your picture bit smaller in the corner. Sometimes, the query gets hidden behind it. Thanks!
Question Set 1 - Easy Notes: Q1: Who is the senior most employee based on the job title? Select * FROM Employee ORDER by levels desc limit 1 Q2: Which countrries have most number of invoices? select count(*) as c, billing_country from invoice group by billing_country order by c desc Q3: What are top three values of total invoice? SELECT total FROM invoice order by total desc limit 3 Q4: Which city has the best customers? We would like to throw a promotional Music Festival in the city we made the most money. Write a query that returns one city that has the highest sum of invoice totals. Return both the city name and sum of all invoice totals. select SUM(total) as invoice_total, billing_city from invoice group by billing_city order by invoice_total desc Q5: Who's the best customer? --The customer who has spent the most money will be declared as best customer. --Write a query that returns the person who has spend the most money. select customer.customer_id, customer.first_name, customer.last_name, SUM(invoice.total) as total from customer JOIN invoice ON customer.customer_id = invoice.customer_id group by customer.customer_id order by total desc limit 1
Hi Rishabh, I really appreciate your content and the significant help you provide for learners like us. I have a question about advanced set question number 1. I believe the question asks for a list of all customers, artists, and the total amount spent by each customer on each artist. The query you provided only focuses on the best-selling artist, which is not what the question is asking for.
Hi folks, csv files link (zip folder):
🔖Music Store zip csv files: shorturl.at/sEIUV
If you are using Postgresql,
Then directly import the database file .sql file. But if you're getting any error in album file then use the below query:
CREATE TABLE public.album2
(
album_id int8 PRIMARY KEY,
title character varying,
artist_id int8
);
- refresh database (now u can see album table there)
- Right click on the ablum table and select the Import/Export option
Then
select the album2.csv file (from your computer)
The file will be imported successfully 👍🏻
Similarly, you can do it for other files.
NOT USING POSTGRE SQL:
2. If using any other sql then,
Use csv files n create your own music database. And for album file, first copy n paste in a new csv file in your computer n then import it to sql. It will work ✌️
Also, if you want help, pls watch my video on - How to import csv files in sql
Keep learning and keep growing!🚀
Please pin this comment, I think it will be helpful. Great project, thank you. Best Wishes.
unhandeled exception charmap codec cant decode file 0*81 in position 4011 character maps to undefined . this error still showing in mysql
@@rizf800follow the above steps n link is updated now
after following the steps mentioned,and while creating the playlist_tracks, it says the error "can't create the table playlist_track, as multiple foreign keys are found"
PLEASE HELP ME IN IT
@@yashshrivastava7541 link is updated now - check pinned comment, follow the steps. just copy paste the query and it will be done
Tareef Karu kya uski jisne aapke Jess teacher bnaya ❤❤best explanation sir❤❤
dost mera toh restore hi nhi ho ra help kr de na
same here@@kamalyadav3612
Wawa wa waa
The best thing about the video is that information is to the point and only as needed.
Glad you liked it ✨️
@@RishabhMishraOfficial SIr please please write add to resume points in my reply ...your writing is so much professional please i wanna add this in resume
@@chakrabartisayantan4013 use chatgpt, prompt what u have done in your resume and ask gpt to write it like as u would write in resume/ short and crisp and highlighting everystep
Hey@@chakrabartisayantan4013
Hey
you saved lakh of rupess , srlsy student dont understand that there is lots of free education on internet, they just have to gain and make some awesome projects but they prefer to spend lakhs of rupees , Thank You Sir For Your Efforts.
Learned a lot from your channel, I have completed this project with 3 days effort because I am a beginner. Please teach us more SQL-related real projects through your channel. Really Appreciate you, BOSS.
Glad you liked ✅️ more project videos will come soon
@@RishabhMishraOfficial thanks a million for the reply
Hiii, I am interested in switching my current field to a Data Analyst job, I find your videos to be engaging, effortlessly comprehensible, and packed with valuable insights. I am watching your videos and practicing. thank you.
Glad you liked ✅️ all the very best 👍
Sir how to add this in resume means what points I have to write please write jn details please it will hardly take your precious 5 minutes. I'm begging to you😢@@RishabhMishraOfficial
First portfolio project video that I am understanding. Thankyou
Glad it was helpful! ✅️
Sir i am new to this field yet i had learn so much from your videos. You really know how to teach, which point to elaborate. Thank you so much sir.
Glad it's helpful ✅️
Hi Rishabh, I am writing this comment at the end of the video, this was my first Data Analytics Project and all I want to say is you're doing God's work out here. In the beginning I struggled a bit but as the video went by things became easier and I got the hang of it. Through the course of the video I got to learn new concepts of SQL as well as brush up my past knowledge of SQL. The video is very well structured and each question is explained very well, crisp and precise. Again, thanks a lot, I really appreciate your efforts, keep it up.
Glad it was helpful ✅️
Keep learning n keep growing 🚀
i need help not able to add data
Congratulations, sir, on reaching 100K subscribers! This is a significant milestone and a testament to your hard work, dedication, and the valuable content you have been providing to us.
Glad you liked ✅️ 👍
Finally, I done my first data analytics project because of you
Thank you sir 🙏
Glad it was helpful! Awesome!
are you able to write 3rd set queries ???
@@devg7929 sure
Hi brother.. Mera name krishna gopal hai
Mai bhut dino se ek sahi mentor dhoond rha tha.. Finally i got you.
Or maine thode din phle hi aapki.. Data analytics road map vali video dekhi. Or uska pdf download krke.. Excel se apna learning process start bhi kr diya hai.. Please hmesha hmaare sath bne rhna.. .. Thanks
May god bless you bde bhai..
Awesome 👌 Keep learning n keep growing 🚀
For those having issues importing the Database file.sql file,
In PostgreSql,
File -> preferences
scroll down a bit
paths -> binary paths
For both server paths make sure your binary path is set:
For instance
EDB Advanced Server 16
I have set it to C:\Program Files\PostgreSQL\16\bin
and then saved it
Hope that helps!
thank you so much for the help
Thank you brother👍
thank u so much brother
Hey, Thank you so much for your help :)
Thanks brother
Guys please share his channel and all videos he deserves million subscribers , your are awesome i mean i saw your video about data analyst roadmap , after i saw that video i thought there is no use to go to institute you have planned the roadmap very perfectly and it look like easy and amazing, and the videos step by step , middile class people can't affort institutes fees but you provide it all free from scratch thats amazing and its free of cost hats off to you bro lots of love and good wishes and one request please make video about data science also like roadmap and all the things you provide in data analysis provide in data science course also it will help me and all students guys share this video please he deserves millions subscribers 😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍
Glad you liked the content Sarvesh ✅️
Thank you soo much for your kind words 💯🚀
@@RishabhMishraOfficial kind efforts required Kind words Data science roadmap please like this video only please with all resources please
Best channel for learning sql and other concept of data analyst
Glad you liked it ✅️
Sir i was able to import the data all thanks to your help, now I can do the project... Once again thanks to the best teacher out there
Awesome 👍 Keep learning n keep growing 🚀
plz tell how you imported..
@@payaltanty6440 hi..are you using MySQL..cause I used that so ..if u are then all you need to do is check for some sort of errors that are in the file..like contents were missing..once done with that ..u are good to go ..let me know again if you still faced the issue ..I will gladly help and once more thing as far i remember in first file only few rows were missing..so check that thoroughly
Thank you, Rishabh Mishra bhai, for being an amazing instructor! I appreciate your guidance and support throughout the video. You're the true GOAT of data analyst!!!
Bhai can you add English subtitle?
Because some of your international viewers facing some difficulties like me.
Best Wishes for your family & you.
FROM
BANGLADESH.
Nice video sir but if possible then please try to explain each query by writing live so that we can see the approach of you while dealing with complex and nested query. It will be very helpful for us.
exactly by writing query live it will be more helpful for us beginners to analyze the approach of the question.
Since I got interested in getting a Data Analyst job, I am binge-watching your videos and practicing. Your videos are very easygoing and rich in content. Requesting you to make an EDA project using python in the future. Thanks in advance.
Yes i uploaded it yesterday
@@RishabhMishraOfficial wow what a coincidence 😅...Thanks😊
Hi, Have you done it? what is your progress
Best teacher for end to end project
Glad you liked it ✅️
I have done this project easy or moderate level boht achay smajh ay Advance level ka first question Thora tricky thay or i recommend k recursive say zada cte acha smajh aya finally i have done😊
Glad it's helpful ✅️
Can you tell me how do I share the project on LinkedIn??
Really good work Rishabh! I really appreciate the way you make things simple .It's really helpful for making projects and also understanding them instead of just copying.Thankyou so much!! Let your channel be reached to more people..!
Glad it was helpful ✅️
Thank you so much you are a gem of a person, amazing project analysis for freshers like us. Really glad for this project.
Glad you liked it ✅️
looks great project ...bring more such content in future
Thank you, I will ✨️
you deserve lakhs of likes, i was searching for this video only , Thank you so much
🤩🤩🤩🤩🤩🤩🤩🤩
Glad you liked ✅️
Thank you sir! for teaching in as easy way as possible, its been helpful for many of us.
Glad you liked ✅️
Namaste...sir🙏
it is very helpful project...nd thank you so much sir for sharing with us
Glad you liked it 💫
Thank you so much for this awesome series.... Kindly make one series on python also......You are awesome work for people like us who wants to start from zero, a big thanks to you 🙏
Very soon 👍
@Prabhat Mishra how to upload this on github
@@Arjun-hc6pe Risabh bhaiya kindly upload and tell how to upload
Great content and much needed for beginners projects in sql, keep making such good videos.😀
Glad you liked it 👍
Also, tomorrow morning i m uploading a very important video for data science jobs that is forecasting. You can watch that as well and can include the skill in your resume
This channel deserves more subscribers ✨
bro mera toh restore hi nhi ho raha help me
Rishab bhai thanks a lot. i have completed my first project in data analysis using sql. you have great teaching skills. lots of love. many thanks :-)
Select * from invoice ❎ Select sab_kuch from invoice ✅
Thank you so much for the portfolio project. Your projects give me confidence that I can enter into data field without worrying about my non-cs background. I have a question here. How do we quantify or measure the insights that we derive out of this project. Any guidance will be very helpful. Thank you again!
You can msg on LinkedIn or lnstagram link in video description
Thank you bhaiya for this project 🙏
Have subscribed your channel please make the video on SQL+python
Thank you, I will 👍
Only point to point information, came to channel only from reel and subscribed.
Big thanks to you sir for your guidance and support throughout this project! 🙌 Your insights made a huge difference. Grateful for the learning experience! 🙏
Glad it's helpful ✅️
Im mysql workbench I am able import all the table excep album.csv table
It's showing unhandled exception: 'charmap' codec can't decode byte 0*81 in position 6012: character maps to check the log for details
save that in csv (comma delimited) format it must be in csv UTF-8 (comma delimited)
@@jyothipuligilla7722 How to do that i'm unable to load album.csv in mysql
Hi Sir, Thanks for this wonderful video. Can you share the summary of this project? what should i write on my resume regarding this project to get more interview calls? please help me out in this. I will a great help for me sir.
You are great and you have shared your experience it's very helpful for us and make some more such kind of video for SQL ,Python , as well as if possible plz make video on power BI
Sure i will ✅️
@@RishabhMishraOfficial experienced person resume me is project ko mention kar sakta hai kya?
simply Superb. This cleared all my doubts on sql
Glad it helped ✅️
Great way of making Zero to Hero.. keep going sir.. it's very helpful
Glad you liked it ✅️
for those who are getting error in restoring the sql file. kindly do the following necessary changes in pgadmin 4 look for File>Preferences>Binary Paths> update the dir location to the C:\Program Files\postgreSQL\16\bin then save it then restore the SQL file.
Thank you
Thank you for sharing ✅️, also you can check pinned comment 👍
Thanks
@@RishabhMishraOfficial Can I load Zip file to SQL SSMS?
Can I load Zip file to SQL SSMS? Do i need to load CSV file one by one?
Hi Rishabh. Firstly, thank you very much for this amazing project. A good way to start enhancing the SQL skills. Just one thing - I was practicing this project following your video, in the advanced level, question 1, do you think there is something missing/correction needed? like how much each customer spent on the top artist instead of how much each customer spent on the artists? Let me know if I am wrong.. Thanks again for this portfolio project. :)
Yes that's exactly what we did. Cte query is for finding the artist name i.e. queen
Exactly..
The question is amount spent by each customer on artists, but the explanation seems to be the amount spent on top selling artist. Correct me If I am wrong. Thank u.
@@venkatashasidharreddychali7485 yes you are right i am trying the same both things are different . explaination is actually for the customers spent total amount on top selling artist where as question is for artists which means all artists . even i got confused
would you please help me how to import database in mysql or mssql .i want to practice this but not able to upload it.Thanks in advance
Thanks a lot for yours videos, these are really helpful to me or new aspirant to learn the data analytics. I had referred more than 5 friends till now, and I am watching your every single video.
Glad it was helpful ✅️
I love you brother .... Bhai aap job chod teaching me aao ... Ek dum fabulous explanation and Quality Content point to point
Thanks Rishabh for such an amazing content. Your explainations are amazing. I have a problem in importing this database to mysql workbench. I am getting encoding error. I tried another way by first creating the database then created tables. But, when I started importing csv data files in mysql workbench using import wizard, it shows 0 rows imported. I tried using copy command that you mentioned in sql tutorial video, still no luck. How to import datacsv files into mysql workbench ?
I am also facing this issue. I am unable to import the dataset using MySQL workbench. Please help me if you find any solutions
I am also facing similar error in MySQL🙁
You can't import postgresql dump files directly in mysql workbench. Either you have to re write the files because both have different syntaxes or you can import these files in postgresql. No other way! I had the same problem.
@@saranshmaheshwari6793 Thanks for the clarification! 🙌🙌
I have a doubt in (ADVANCE ques -1) the question says " amount spent by each customer on ARTISTS " but in the video in CTE you take LIMIT 1 which gives you the top artist only. why????
Same doubt, just because of this doubt I wasted 3 hours
yes, question should be changed
@@sarwarayaanali272 So did you get any solution to this?Should the question be different. I believe this must be the desired query for this question:
select c.customer_id,c.first_name,c.last_name,at.name,
sum(il.unit_price*il.quantity) as total_amt_spent
from customer c join invoice i on c.customer_id=i.customer_id
join invoice_line il on il.invoice_id=i.invoice_id
join track t on t.track_id=il.track_id
join album a on a.album_id=t.album_id
join artist at on at.artist_id=a.artist_id
group by 1,2,3,4
order by total_amt_spent
Do let me know your thoughts on this. Thankyou so much. Awaiting response as I'm also scratching my head for last one hour.
Thanks a lot sir , your content is so unique and easy to understand. You don't know how much helpful it is for me.
Glad it was helpful ✅️
great content, seriously you are helping millions of students who are struggling with these topics... Thankyouuu sir.
Thank you for making these!! I'm following all of your videos :)
I'm doing this project now and the advanced level is so hard.... but I'll keep practicing 🫡
Awesome ✅️
Thank you Rishabh Bhai! It was really very informative. It's because of your teaching, am able to grasp the concepts much better!
Glad you liked ✅️
Very Helpful And Clearly Explained
Thank You Very Very Much Sir🙌❤
Thanks a million Sir ......Must say you are helping to many Indians through your content!
requesting please light on my below queries !
1- I m working on MS SQL Server so just wanna to know is it good to extend my skills on it or should I move to MY SQL!
2- in real time how to refresh data from SQL data base to Power bi reports!
3- DO you have video on SQL data cleaning if yes then pls let me know the path!
U r my fav one sir❤️🤜🤛
bhai you are the best teacher to teach sql
help me dude. can't import csv files..
one of the best video and explanation for sql concept
thankyou bro i learned a lot 🥰
Happy to help ✅️
Rishabh its very nice project, i learned so many thing from u, in future will learn too. Kindly make one vedio about Views,Indexes with project examples.
Thank you Rishabh Sir for making such a useful video , Thanks
Glad you liked it ✅️
Good to see these vedio of joining tables multiple things.good to know on practical things rishabh mishra
Glad it was helpful ✅️
Thank you for the project and SQL . The database link is not working but I copied the data from csv to Postgresql and it works .It is matter of 8 tables to be copied so I think it is doable. Thanks for the insight
Awesome 👌 I'm glad you completed the project.. keep learning n keep growing 🚀
The best channel ever.
Hi Rishabh Thank you for being a Data analyst mentor ❤
Glad you liked the content ✅️
Thank you so mush for the content you provide us, I have watched some of your videos on SQL and excel despite I didn’t speak or understand Hindi I use the caption. I wish if you make the video in English so that a lot of people can benefit from your content. I appreciate your effort thank you
Glad it was helpful ✅️
Tbh Rishabh bhaiya you are gem for our generation i enjoyed your video's it is help me a lot. Your video increase my confidence. Thankyou so much bhaiya for making such a amazing videos
Glad it's helpful ✅️ keep learning n keep growing 🚀
Awsome content brother.....keep up....respect from Bangalore.
thank you bhai multiple complication you can easy way to explin us ...best bro❤
Thank you brother very informative.... N useful .
Thank you so much for helping learn SQL..
Glad it was helpful! ✅️
Thank You So Much for this easy Explanation ❤
Glad it was helpful! ✅️
Thank you Rishabh. This video is very helpful 🥰
Glad it was helpful! ✅️
Wonderful brother... Keep it up
Great project !
Glad you liked it!
mishra jiii ek no concept 👍👍
All the way great video. ❤❤❤❤. Kindly make advance sql project
Glad you liked ✅️ n noted ✅️
this wad good please give us all category beginners to advance projects
Okay noted ✅️
Nice video really helpful for beginners thanku soo much❤
Glad it was helpful ✅️
you are simple and awesome sir
Glad you liked it ✅️
Thank you Sir ji for this amazing video😍
Glad you liked ✅️
Nice selection of database. Perfect for beginners to let go of their fear of multiple joins. Now only if someone could explain how is the group by clause not throwing error for when we don't include all other columns in it (except functions). I have used hive servers mainly and it does not allow having aggregate functions and other columns in select clause unless all other columns of select clause are also in group by clause.
hello rishab your way of teaching is very easy to understand and your usp mean Hindi language is really a good choice to distinct from crowd but i need one help just that i have mysql not Pg either please also provide database in mysql or teach us to install Pg
Yes, there is already a video on this channel how to download n install postgre sql
The contents are awesome and kindly teach in English completely.
Thx it was help ful plz do repeat this kind videos
Okay noted ✅️
Thank you sir
You are the best
All the best
Thanks, Manish sir, actually, I didn't have any idea about CTE but now I have it.
especially thanks and can you please make more videos of sql projects only not for powerbi projects.
Excellent content ❤
Thank you so much ✅️
You explained in good way ,i found in Advanced query section last 2 question u solved by using Recursion (2nd method) but actually its not recursion function u simply used 2 temp table .u not even using correct recursion syntax.see i might be wrong ,just observed and i thought i should inform here
3:20 when I restore file I got " restoring backup on the server 'PostgreSQL 16 (localhost:5432)'
many thanks sir, god bless u
Hi Rishabh sir..., I’m really interested in learning more about topic like TH-cam Analytics and SQL projects. Could you please make a video on topics like analyzing video performance, viewer demographics, and engagement metrics using SQL? It would be really helpful for my project!
Thank you for your great content!..
12:30:33 select customer.customer_id, first_name,last_name,sum(invoice.total) as invoice_total from musical_database.customer join musical_database.invoice on customer.customer_id = invoice.customer_id group by customer.customer_id order by invoice_total desc limit 1.... Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column... plz look into this sir
Thank you Sir for this amazing content.
Glad you liked it
Hi Rishabh sir, I'm so grateful that somehow I found your channel to learn data analysis concepts. With the help of this video, I have created my first data analysis project using SQL. Thank you so much for your efforts. Upon completion of this project, I was wondering whether data visualization of these same questions can be done using Excel or Power BI. And if yes, then please guide me through the process.
Glad you liked ✅️ n yess you can do it using data visualization tools
Thankyou sir, your videos are very helpful.
Thanku so much u r really great teacher
Glad you liked the content ✅️
Keep learning n keep growing 🚀
Thanks, Rishabh, for your valuable videos. Just one suggestion please, could you pls make your picture bit smaller in the corner. Sometimes, the query gets hidden behind it. Thanks!
Question Set 1 - Easy Notes:
Q1: Who is the senior most employee based on the job title?
Select * FROM Employee
ORDER by levels desc
limit 1
Q2: Which countrries have most number of invoices?
select count(*) as c, billing_country
from invoice
group by billing_country
order by c desc
Q3: What are top three values of total invoice?
SELECT total FROM invoice
order by total desc
limit 3
Q4: Which city has the best customers?
We would like to throw a promotional Music Festival in the city we made the most money.
Write a query that returns one city that has the highest sum of invoice totals.
Return both the city name and sum of all invoice totals.
select SUM(total) as invoice_total, billing_city
from invoice
group by billing_city
order by invoice_total desc
Q5: Who's the best customer?
--The customer who has spent the most money will be declared as best customer.
--Write a query that returns the person who has spend the most money.
select customer.customer_id, customer.first_name, customer.last_name, SUM(invoice.total) as total
from customer
JOIN invoice ON customer.customer_id = invoice.customer_id
group by customer.customer_id
order by total desc
limit 1
could you please also share for question set 2? I am getting error for 1st question in set 2. Thanks
will do. give me sometime sis.@@riyamody6544
Hi Rishabh,
I really appreciate your content and the significant help you provide for learners like us.
I have a question about advanced set question number 1. I believe the question asks for a list of all customers, artists, and the total amount spent by each customer on each artist. The query you provided only focuses on the best-selling artist, which is not what the question is asking for.
Nice and best explain with your hard working on video please make video on power bi
Glad you liked ✅️ Power bi videos are already uploaded on this channel
Thankyou so much for your efforts bhai.
best explanation
Glad you liked