I solved the problem that Ask Interview 4 business analyst profile.

Hello everyone I am telling you how to solve this types of problem when you face in your business analyst field or data analyst field first of all start with creating database give the name and use the database after that create a table in this there are you have many tables in this point of time like I have four tables customer store product and sales I create it all four tables with the help of code you can see in my video after that I give them a primary key so when I join them it can help me so we can do it easily after that I insert a datas for customer it was seen like as Excel sheet in the downside of the after that my question was find the customer who has to purchase most product so how I approach first I select customer name and then the sum of the amount to death I go in a sales join customers customer ID group by customer name order by total products and describe.