How to use sub query in MySQL DELETE statement?

Just simple as bellow: