I was able to complete the above SQL query as seen in https://quarry.wmcloud.org/history/84807/911494/884555.
However, when I run the same query again at https://quarry.wmcloud.org/query/84807 . I got the error "OperationalError('table resultsets already exists')". How should I fix the error?
I guess that resultsets may be a temporary table that was produced from running my previous SQL query. I tried to execute the following:
DROP TABLE IF EXISTS resultsets;
However, I got the following information: “Access denied; you need (at least one of) the SUPER, READ_ONLY ADMIN privilege(s) for this operation”
May anyone help me on this issue?
Thanks.