Problem
Write the SQL Commands based on following tables
Department(dept_name, building, budget)
Student(ID, name, dept_name, tot_cred)
Instructor(ID, name, dept_name, salary)
Course(course_id, title, dept_name, credit)
Takes(ID, course_id, sec_id, semester, year, grade)
Teaches(ID, course_id, sec_id, semester, year)
Section(course_id, sec_id, semester, year, building, room_number, time_slot_id)
Prereq(course_id, prereq_id)
Advisor(s_ID, i_ID)
• How many students who earned grade A in 2007?
• Find all student's names who are in classes of instructor 'DAgostino'
• Find the course ids that had section in the same building as department's building that offered those courses.