help me solve this problem so it outputs the expected result:

Result:

$```$

Grading: FAIL: Your SQL statement outputs the expected result. $\backslash ((9/25)\backslash )$

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 JOIN 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 an DESC clause. $(10/10)$

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

FAIL: Problem $(89/105)$