3- Solving Tricky Sql Query - Advance Case and Aggregate Statements #sqlforbeginners

[ashishkumarkaushal]

select sale_date, sum(case when fruit='apples' then sold_num end)-sum(case when fruit='oranges' then sold_num end)
from sales group by sale_date;

[priyankachahande]

Why you use Case, how we come to know we have to use case or any concept, How we know from questions that okay now we have to use CTE or case or any concept
Can you please answer this ?

[yaserarafath]

Assalamu alaikum jumma mubarak madam pls send me your account number to pay amount for crack interview sql book. I don't have net banking account and mobilekiwi account

[yaserarafath]

Assalamu alaikum jumma mubarak madam pls send me your account number to pay amount for crack interview sql book. I don't have net banking account and mobilekiwi account