I'm new to Apache CouchDB database.

I have a list of all video (about 10M video, each video has a propery named Category ) and a list of user watched video. How do I write View and query to get list of un-watched video belong to specified user id and category ?

Because it's not like SQL, so I have no idea to try to write my own.