Here's why:
* Adjective clauses modify (describe) nouns or pronouns.
* Adverb clauses modify verbs, adjectives, or other adverbs.
In the sentence "I want to know who can cook," the clause "who can cook" modifies the noun "who." It tells us *what kind* of person is being sought.
Let me know if you have any other questions!