Output how many rooms there are? (Answer: 3)
Output dean of Eco faculty?
Output all students' names and surnames in the following format B. Gates. (hint: use x.substring(0, 1)
)
Output class name and how many students in class
Answer: CS 111 5 students
CS 102 6 students
Output how many courses there are?
Output grades of 0-th course
Output sum of grades of 0-th course
Output all courses, show only it's subject code:
Answer
CS 111
MAT 101
GEN 101
GEN 102
JUR 101
Output all courses and how many schedule for each course:
Answer CS 111 2 schedule
MAT 101 1 schedule
GEN 101 1 schedule
GEN 102 2 schedule
JUR 101 2 schedule
Output all courses that are hold on Thursday. Output only subject title and schedule
Output all course that are taught by PhD instructors
Output all courses' title, instructors full name, and grades field is present, if grades is not present write no grades