You can delete any queries you have created. If the query is being used on a workspace, the workspace will no longer work.
You cannot delete the default queries. You can only delete modifications you have made to a default query. For more information, see How workspaces and workspace content is stored.
This process is also used to delete a modification to a default query.
Open: Workspace Designer > Content Part Designer > Query Editor.