Thanks.

Can somebody help me with this error

should match the expected
rows did not match expected
@@,sailor_senshi ,real_name ,cat ,school
,Sailor Moon ,Usagi Tsukino,Luna ,Juuban Municipal Junior High School
→ ,Sailor Mercury,Ami Mizuno ,Luna ,TA Academy for Girls→Juuban Municipal Junior High School
→ ,Sailor Mars ,Rei Hino ,Luna ,Infinity Academy→TA Academy for Girls
→ ,Sailor Jupiter,Makoto Kino ,Luna ,Moto Azabu High School→Juuban Municipal Junior High School
→ ,Sailor Venus ,Minako Aino ,Artemis,NULL→Juuban Municipal Junior High School
→ ,Tuxedo Mask ,Mamoru Chiba ,NULL ,NULL→Moto Azabu High School
→ ,Sailor Uranus ,Haruka Tenou ,NULL ,NULL→Infinity Academy
→ ,Sailor Neptune,Michiru Kaiou,NULL ,NULL→Infinity Academy
→ ,Sailor Saturn ,Hotaru Tomoe ,NULL ,NULL→Infinity Academy
: ,Sailor Pluto ,Setsuna Meiou,NULL ,NULL

Can you explain why so? thanks.

I think you are making the same mistake as I did, where in your code is trying to display 5 books (random) but not the top 5. what you can do is write a select statement that arranges the books in descending order (based on volumes sold) and limit the rest to 5, which will result in the top being displayed.

Hope this helps.

SQL- The test case checks if the select query is returning 5 books, but not verifying if those 5 are the top selling once.

or am I interpreting it the wrong way? can somebody help?