help me solve this problem so it outputs the expected result: Instructions: popular one. If an item has no sales then it does not need to be listed.

Database: grader$\_$rollarama Schema

Show all table rows.

Enter Code:

$```$

select stock$\_$num, sum$($quantity$)$ as total$\_$sales

from transaction

where stock$\_$num in $(101,201,202,203)$

and store$\_$num in $(1,2)$

and quantity $>0$

group by stock$\_$num

order by total$\_$sales desc;

$```$

Execute

History

Result:

Expected:

Grading: $\backslash (\backslash$quad $\backslash )$ FAIL: Your SQL statement outputs the expected result. $(30/50)$

Pass: Expecting $1,$ found $1-$ Your statement should start with SELECT. $(10/10)$

Pass: Expecting $1,$ found $1-$ Your statement should include a FROM clause. $(10/10)$

Pass: Expecting $1,$ found $1-$ Your statement should include a WHERE operator. $(10/10)$

Pass: Expecting $1,$ found $1-$ Your statement should include a GROUP BY operator. $(10/10)$

Pass: Expecting $1,$ found $1-$ Your statement should include an ORDER BY clause. $(10/10)$

Pass: Expecting $1,$ found $1-$ Your statement should include a DESC. $(10/10)$

Pass: Expecting $1,$ found $1-$ Your statement should end in a semicolon. $(10/10)$

Score:

FAIL: Problem $(100/120)$