Note: Please concentrate on the last two (a and b) points. this is the 3rd time I'm posting this Question. Give Accurate Answer.

Create Schema the following schemas

I) Student (Student_id, name,gender , age, address)

II) Course (course_id, name, credit hours)

ii) Department (id, Name, location) Insert at least 6 dummy record in schemas having first record of "Adam" in students table.

a) Select (name, age) from student table and (course, credit hours) from course table with the help of sql join query, assign all course subjects to "Adam" Only.

b) Select top 3 records with minimum age and maximum age from student table.