Please help with statements. I$\text{'}$m using Oracle Developer$-$mySQL for Relational Database course. Thank you

Q$1.$ Show which course has the lowest cost. Display course no$,$ description, and cost $($HINT: use a subquery$)$

Q$2.$ List all Java Programming related courses that have a prerequisite. List course no$,$ description, prerequisite course no$,$ prerequisite course description

Q$3.$ Show which course has the lowest section capacity. Display course no$,$ course description, section no$,$ and capacity $($HINT: use a subquery$)$

Q$4.$ For each city in the MA state, calculate and display the number of zipcodes belongs to that city. List city, state, and zipcode count

Q$5.$ For all Programming related courses, list their total number of sections and total section capacity. Show course description, section count, and total capacity. Sort the result by total capacity in descending order

Q$6.$ List all cities that have at least $8$ students. Display city, state, number of students live in that city

Q$7.$ Consider the grades for course sections of Intro to Programming, per each grade type code calculate and list numeric grade statistics. Display grade type code, lowest grade, highest grade, average grade, and number of grade counts

Q$8.$ For all students who have taken Intro to Programming, show how many students who were given the lowest Midterm grade $($grade$\_$type$\_$code MT$).$ Show student count.

Q$9.$ For all students who have taken Intro to Programming, list those who were given the lowest Midterm grade $($grade$\_$type$\_$code MT$).$ Display student first name, last name, course description, section ID$,$ grade type code, and Midterm grade

Q$10.$ Show all courses that are near their capacity $($defined as across all sections, the total number of enrolled students is within $20$ or less of the total capacity$).$ Display course no$,$ description, number of total enrollments, and total capacity