How do I create a query that shows the score of the student with the lowest English score?

[Cat Ball]

How do I create a query that shows the score of Math and Chemistry of the student with the lowest English score?


(With SQL coding)

StudentInformation:


Math score:


Chemistry score:


English score:

[orange]

Try

select studentid,math, chemistry from catBallT 
where studentid =(SELECT b.studentid
                                   FROM CatBallT as B
                                  where english = 
                                          (select min(c.English) from catBallt as C
                                          )
                                   )

[Cat Ball]

thank you!!!!