NOT replaced by ! is not working in n1ql, but works in sql

Create a simple doc with contents:

{

  "name": "prerna"

}

Issue a simple query:

select * from simple_table_1 where (name = "prerna");

works correctly

Same query if written as:

select * from simple_table_1 where NOT(name != "prerna");

works correctly.

But following query does not give any result:

select * from simple_table_1 where !(name != "prerna");

Both queries result in correct results in mysql.