Loading collection data...
Collections are a way for you to organize kata so that you can create your own training routines. Every collection you create is public and automatically sharable with other warriors. After you have added a few kata to a collection you and others can train on the kata contained within the collection.
Get started now by creating a new collection.
Thanks.
On your last join statement, you have
id
instead ofschool_id
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.
Are you sure? I'm bad at SQL, but if I try to just select 5 books I get the following error:
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?