Question Delete the record of all accounts with balances below the average at the bank.

then I write mysql like this:

DELETE FROM accounts WHERE balance<(

SELECT AVG(balance)

FROM balance

);

its wrong, and ide said: You can't specify target table 'account' for update in FROM clause

Please help me change to the right sentence. I googled, they said "In Mysql, you can not update one table by subquery the same table."