Hi Nika,
Thanks for your Reply...
I had checked in my environment using superuser account "Enable view query in Adhoc Editor" is checked .Yet the users are not viewing the "View SQL Query" option at Adhoc View in Advanced Reporting.
Note: This "View SQL Query" option is not showing at Adhoc view in Advanced Reporting for the users.