ðÒÉ×ÅÔ.
îÁ×ÅÒÎÏ ÓÎÁÞÁÌÁ ÐÏÛÅÌ ÐÏ ÎÅÐÒÁ×ÉÌØÎÏÍÕ ÐÕÔÉ.

ÅÓÔØ ÔÁÂÌÉÃÁ Students (PK,fio...)

É ÔÁÂÌÉÃÁ students_vs_groups(GROUP_ID,ACTUAL_DATE,STUDENT_ID)

÷ÒÏÄÅ × ÐÏÓÌÅÄÎÅÊ  ÐÅÒÉÏÄÉÞÎÏÓÔØ ÐÒÉÓÕÔÓÔ×ÕÅÔ.
âÙÌ ÓÔÕÄÅÎÔ ×ÞÅÒÁ × ÇÒÕÐÐÅ ÐÅÒ×ÏÊ (ÐÅÒ×ÁÑ,ÓÅÇÏÄÎÑ, ÓÔÕÄÅÎÔ).   úÁ×ÔÒÁ ×Ï 
×ÔÏÒÏÊ  (×ÔÏÒÁÑ,ÓÅÇÏÄÎÑ, ÓÔÕÄÅÎÔ).

îÏ ×ÏÔ ËÁË ÐÒÉ ÔÁËÏÍ ÒÁÓËÌÁÄÅ ÐÏÌÕÞÉÔØ ÓÐÉÓÏË ÓÔÕÄÅÎÔÏ× Ó ÎÏÍÅÒÁÍÉ ÇÒÕÐÐÕ ÎÁ 
ÔÅËÕÝÕÀ ÄÁÔÕ?

Join Ó students_vs_groups ÂÅÓÐÏÌÅÚÅÎ, Ô.Ë. ÎÁÄÏ ÏÇÒÁÎÉÞÉ×ÁÔØ ÄÁÔÏÊ É select 
first 1. îÏ × join ÜÔÏ ÂÅÓÐÏÌÅÚÎÏ. á ÍÏÖÅÔ ×ÙÌÅÚÔÉ ÎÅÓËÏÌØËÏ ÓÔÒÏË ÎÁ 
ÓÔÕÄÅÎÔÁ.


C Õ×ÁÖÅÎÉÅÍ 



Ответить