views query I can't workout
You need to use views contextual filters. Add a contextual filter Content:Nid and provide default value as "Content Id from URL" and select Exclude checkbox in the settings. That's it !!