Data Analyst SQL Project Beginners Solve Real Business Problems PostgreSQL & MySQL Datasets #08/10

[@Pavankumarreddy-s7p]

Providing very Good knowledge and information through your videos. Thank you soo much..! please continue to upload python data analyst series.

[@secret_step]

Indeed an interesting video.The queries were quite long to understand. But I know practice will make one perfect. Thanks Bruh.

[@sahilpathare8060]

Thankyou really helpful

[@mohammadsaifi8883]

Great video!🎉 If there would be timestamp in the videos then it would be really helpful.

[@zero_analyst]

Noted!

[@AlaaMohamed-d6c]

Thank you for this great video

[@avinayakchoudhary4172]

Hii Sir, Please start a series on SQL in Hindi ! It would be really helpful. 🙏🙏🙏🙏🙏🙏

[@zero_analyst]

I wish i could! My Hindi is not good!

[@ajayDogra-q3y]

​@@zero_analystesa kya mars se aaye ho bhai?😂please share your lecture in hindi I know English but sometimes I got perplexed in words😢

[@nidhikumari1350]

In Q5. Question is to find avg(amount) for per customer but you are finding out city wise. will you please check this

[@babazaid9539]

yeah i also got confused at first the question is asking per customer and he has taken out the average of total customers in each city

[@ArifKhan-nh6gc]

What are then main points we can add in resume for this project so that we resume have good ats score?

[@hemantsahoo7887]

Hi Najir what is the source of the dataset, If I want to add it to my resume, for example, can I say the source of dataset is Kaggle (where it is already present?) or somewhere else show I can say demonstrate the recruiter in future

[@zero_analyst]

It’s created by me mate! You can simply say sourced - Zero Analyst

[@alhussena]

when importing the csv files for the tables i get an error for columns not sure why

[@MavisMasikati]

my one it shows error any help

[@abhilashreddyanugu6457]

hi sir, Can I add this project to my Resume?

[@zero_analyst]

Yes you can!

[@jayasuriyaa.d.7018]

7 th problem where s,product_id

[@ArifKhan-nh6gc]

How did you changed your theme in pgadmin?

[@zero_analyst]

Go to settings - miscellaneous - change theme to dark!

[@Skyler_04-m7l]

go to file - then prefrences - then scroll down , you will theme option over there

[@feliciaatieno4190]

Hi, do you have any projects with SSMS?

[@zero_analyst]

You can do all these project in any RDBMS!

[@ShivaSai000]

How to find er diagram in mysql

[@prathittijare2825]

Great project, Explaination too. Sir, I am when I try to import sales CSV file in MySQL workbench It is showing 8038 records only but there is 10388 records there. what should i do??

[@zero_analyst]

Are you using Mysql or Pgadmin 4??? If you are using MySQL try importing cmd line!

[@harjotsingh7132]

Hi, you need to format the csv file first sale_date - yyyy-mm-dd drop table if exists sales; create table sales ( sale_id int primary key, sale_date date, product_id int, customer_id int, total float, rating int ); use this format for sales.csv please let me know if this works for you.

[@prathittijare2825]

@@zero_analyst Done. Thank you

[@prathittijare2825]

@@harjotsingh7132 Done. Thanks buddy

[@kabirwasim2784]

ok

[@Rand681]

1st :)

[@gospelmoto2833]

My solution to Q7: -- 7. **Customer Segmentation by City** -- How many unique customers are there in each city who have purchased coffee products? SELECT ct.city_name, count(distinct s.customer_id) AS Unique_No_Customers, count(s.product_id) AS product_count_ordered FROM sales s JOIN customers c ON s.customer_id = c.customer_id JOIN city ct ON c.city_id = ct.city_id GROUP BY 1 ORDER BY 3 DESC, 1;