Please correct my SQL attached, I believe it's the WHERE function because it runs correctly without it but I am not sure how to get the desired outcome of the $"2$ top ranked"

Revise the query from the last problem: when there is a tie of quantity$\_$rank, assign

the same rank to each tied row, but ensure that the next rank in the sequence is not

skipped. Filter the results to only show the rows of the top two quantity$\_$rank.

Hint: consider using subquery.

c$.$customer$\_$first$\_$name,

c$.$customer$\_$last$\_$name,

cp$.$quantity,

DENSE$\_$RANK$()$ OVER $($PARTITION BY c$.$customer$\_$first$\_$name, c$.$customer$\_$last$\_$name

FROM

customer c

JOIN customer$\_$purchases cp ON c$.$customer$\_$id $=$ cp$.$customer$\_$id;

WHERE quantity$\_$rank $=1$ AND $2$;

ORDER BY

c$.$customer$\_$last$\_$name,

c$.$customer$\_$first$\_$name,

quantity$\_$rank;