For removing data like removing campaigns, you cannot use AWQL as "DELETE" query is not supported, only the "SELECT" query is supported. You can refer to this
example on how to remove a data particularly a campaign. You can also refer to this
guide for more information regarding AWQL.