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.
Right... Good call. In that case, the sales table should have a default for the department id field set to 0, and then the unknown row would have an ID of 0
Because id cannot be null in table departments (cause PK), then no values will be provided for result.
If the db is built properly, the departments table would have a null row that would have the name "Unknown"
This comment is hidden because it contains spoiler information about the solution
From a mathematical standpoint, returning zero is not that bad. Only if the calculation really was wrong you should throw an error (inserting letters for example)
fair enough :
@renjia93 , I hereby register my opinion that it's wierd to expect 0 in above case.
just an opinion of course :)
Hey.
We expect 0 in this case because that was the challenge set by @renjia93 for this kumite. Namely
why do we expect 0 in this case?