Category "where-in"

SQL- Find all students who all of their friends have score less than 10

I have to write some simple queries for my database homework using SQLServer. The schema has been provided in the question: students(student_id, name); friends(

Is there a way to search one table for certain values, and if successfully found, then update a different table?

Good afternoon all, This is my first time using SQL, so forgive me for being new. I have three different tables that I've created: CREATE TABLE employee (ID int