How to implement this in SQL?

Question

PHP

There is the following table structure:

There is the following code:

/ позбатомися о том, чтобы не было не было ответов с заминусованым рейтингом
    $answers = $wpdb->get_results("SELECT DISTINCT `expert_id` FROM texperts_answers", ARRAY_A);
 
    // пройдем по каждому ответу
    foreach($answers as $i => $answer)
    {
        // получим его рейтинг
        $rating = $wpdb->get_var("SELECT SUM(`rating`) FROM texperts_answers WHERE `expert_id` = " . $answer['expert_id']);
 
        // если рейтинг меньше 0, то делаем его раным 0
        if ($rating < 0) {
            $wpdb->query("DELETE FROM texperts_answers WHERE `expert_id` =  ". $answer['expert_id']);
        }
    }

How to implement the same, but within the framework of SQL, without using PHP?

Answer 1

Something like this:

delete from texperts_answers 
where `expert_id` in (SELECT `expert_id` FROM texperts_answers 
group by `expert_id`
having SUM(`rating`)<0)