SQL questions

I need 5 out of the 7 SQL questions answered. The table is uploaded to answer the qustions.

The problems below are for the first discussion thread in Week 2. 
1. Create a SQL query that extracts all departments and the courses that are within that department. Order the data by program in ascending order.
2. Create a query that lists all students’ last names and first names, the description of the program they are pursuing, the number of credits they have, and the total required credits for the program. Order the list by Student Lastname in descending order.
3. Create a list that shows each course code, course description, and studentID, along with the student’s mark in that course. You do not have to list the student’s name. Order the data by course description in ascending order.
4. Show all course IDs for a student named Jose Ramirez. Include Jose’s last name, first name, and grade in each course.
5. Create a list of students and the programs they are pursuing. List only those students whose number of credits is less than the required credits in their program. 
6. Show a list of all courses, their credit hours, and descriptions of their departments. 
7. Show a list of all courses, their credit hours, and descriptions of their departments. Include only those courses whose course code starts with an M.