I guess you are looking for a AND in the query.

Try this

SELECT Student

FROM TableA M

WHERE EXISTS (SELECT 1 FROM TableA S1

              WHERE S1.Student = M.Student

                AND S1.NumberOfTests >= 2

                AND S1.Percent >= 30)

  AND M.NumberOfTests >= 1

  AND M.Percent >= 40