The Advanced (SQL) tab shows the exact SQL syntax for List and Pivot Table views. The owner of the view can edit this SQL statement.
Advanced users and administrators can use this option to write their own SQL statement WHERE or ORDER BY clauses or to edit the SQL statement that is automatically generated by the system based on the standard configuration options. Advanced (SQL) Tab 
Keep in mind the following when working with the Advanced SQL tab:
...