Data Analyst Interview | Python Interview | SQL | POWER BI | Must Watch!!! 

Sure we will share, please text us @7205617787

I too would like to know. I am still learning SQL and think your answer is appropriate. Sum gives total but not individual top 3 sales.

First, you need to mention "sum" because there is no total sales amount in the given table. Second, you are taking "category" with an aggregate function "sum", so you should use group by. Third, you cannot use aggregate functions such as sum with where clause so sum(total_price) > 5000000 has to be used in having. so, the query will look like this- SELECT category, SUM(price) AS total_sales FROM sales WHERE category != 'Tobacco' GROUP BY category HAVING SUM(price) > 500000 ORDER BY SUM(price) DESC LIMIT 3

@@aish000 may be your answer is correct on your perspective. My suggestion is you have to check the Question

@@WhatshappeningUf You said "correct me if I am wrong." So I did. It is not about perspective. It is the answer to the question. Look at the table, the columns, and the question, you will get it. Also, to confirm, I ran the query and got the answer. You answer is correct if there is a table with sales amount for each category. This is different.

@@aish000 that’s cool, appreciate

Pls send your profile to info@talentele.in

I have sent the details

Exactly what I was thinking. After the changes are committed, you need to retrieve the deleted data from the backup.