Course (CourseCode, CourseName, Year, Semester) course schedule

SQL Misolcha 4

Quyidagi table lar berilgan. Table malumotlarini bazadan ko’rishingiz mumkin.

COURSE (CourseCode, CourseName, Year, Semester)
COURSE_SCHEDULE (CourseCode, DayOfWeek, StartTime, EndTime, Room)

1. 
   Yil, semester va xafta kunlari bo’yicha darslar soati miqdorini toping.
   
2. 
   Xaftasiga 6 soatdan ko’p dars bo’ladigan 3chi kurs fanlarning kodi, nomi, xaftalik darslar soati ni toping.
   

3. 
   Birinchi kurs fanlari umuman o’tilmagan xonalarni toping.
   .
   
4. 
   3chi kurs fanlaridan umumiy xaftalik darslar soati 10 soatdan balant va dars kunlari xaftaning 3ta turli kuniga to’g’ri keladigan kurslarning kodi, nomi, va xaftalik umumiy soatini toping.

   10 bilan vaqt intervalini solishtirish uchun (10 * '1 hour'::interval) dan foydalaning.