SQL更新在哪里(列表)或每个单独更新?

I'm doing my best lately to look for the best way to run certain queries in SQL that could potentially be done multiple different ways. Among my research I've come across quite a lot of hate for the WHERE IN concept, due to an inherent inefficiency in how it works.I'm doing my best lately to look for the best w