a$-$ display the first and last name, and mark for the student who their marks less than $50.$

b$-$ display the first and last name, and mark for the student who their marks more than $50$

display the result in ascending order of mark.

c$-$ use subqueries to display the subject name who all students passed their subject.

d$-$ display the student$$s first name, last name, subject name, and mark with the mark of

more than $70.$

e$-$ Use subqueries to display the subject name and subject number who have more than

one student enrolled in the subject.