3
| : . . | : 3- -1644 . . |
2016
3 (2 .).
: .
: , .
:
1. , 2 .
2. , ( SELECT).
3. .
4. .
7:
1. 605.
2. 5 .
3. , ++.
4. , .
5. , .
:
, :
1). select * from student;
. 1 student
2). select * from laboratories;
. 2 laboratories
3). select * from rozklad;
. 3 rozklad
4). select * from groups;
. 4 groups
5). select * from predmets;
. 5 predmets
:
1). select predmets.title, laboratories.provision from predmets, laboratories, rozklad
where rozklad.id_predmet=predmets.id_predmet and rozklad.room_number=605
group by predmets.title;
. 6 605
2). select * from student order by name desc limit 5;
. 7 5
3). select * from laboratories where title like "%c++%";
. 8 , ++
4). select laboratories.title, count(*) as ' '
from laboratories, rozklad where laboratories.number_room=rozklad.room_number
group by laboratories.title;
. 9
5). select * from predmets where week(start_date)=week(curdate());
. 10 ,
:
1). select count(*) as ' ', count_hour as ' ' from predmets group by count_hour;
. 11 ( ) ,
|
|
|
2). select * from predmets order by start_date asc;
. 11 ( ) , start_date
(group by), (order by).
