1. ?
SELECT DISTINCT Name
FROM "worker.DB"
WHERE
(Skill_type = '')
ORDER BY Name
2. .
ELECT DISTINCT Bldg_id, Adress, Type, Qlty_level, Status
FROM "building.db"
WHERE
(Type = '')
ORDER BY Bldg_id, Adress, Type, Qlty_level, Status
3. ?
select Name,'Íåäåëüíàÿ çàðïëàòà=', 40 * Hrly_rate
from "worker.db"
where (Skill_type='')
order by Name
4. 10 12 ..?
select *
from "worker.db"
where Hrly_rate between 10 and 12
5. , ,.
select *
from "worker.db"
where Skill_type in (','','')
6. , .
select *
from "worker.db"
where skill_type like ('%')
7. , .
SELECT DISTINCT Worker_id, Bldg_id, Start_date, Num_days
FROM "assignment.db"
WHERE
(Start_date >= '10/10/2005')
AND (Start_date <= '10/10/2005'+(14.0))
ORDER BY Worker_id, Bldg_id, Start_date, Num_days
8. , 435?
SELECT DISTINCT D1.Skill_type
FROM "assignment.db" d, "worker.DB" D1
WHERE
(d.Bldg_id = 435.0)
AND (D1.Worker_id = d.Worker_id)
ORDER BY D1.Skill_type
9. , .
SELECT DISTINCT D.Name, D1.Name
FROM "worker.DB" D, "worker.DB" D1
WHERE
(D1.Supv_id = D.Worker_id)
ORDER BY D.Name, D1.Name
10. , .
SELECT DISTINCT D2.Name
FROM "assignment.db" d, "building.db" d1, "worker.DB" D2
WHERE
(d1.Bldg_id = d.Bldg_id)
AND (d1.Type = 'Îôèñ')
AND (D2.Worker_id = d.Worker_id)
ORDER BY D2.Name
( )
11. , 435?
select skill_type
from "worker.db"
where Worker_id in
(select worker_id
from "assignment.db"
where bldg_id=435)
12( , ). , .
select Name
from "worker.db"
where worker_id in
(select worker_id
from "assignment.db"
where bldg_id in
(select bldg_id
from "building.db"
|
|
where type= 'Îôèñ'))
13( , , ). , , .
SELECT Name
from "worker.db" d1
where d1.hrly_rate >
(select d2.hrly_rate
from "worker.db" d2
where d2.worker_id=d1.supv_id)
EXISTS NOT EXISTS
( )
14( ). , 435.
select worker_id
from "worker.db" d1
where not exists
(select *
from "assignment.db" d2
where d2.worker_id=d1.worker_id and bldg_id=435)
14_1( ).
select worker_id
from "worker.db"
where worker_id not in
(select worker_id
from "assignment.db"
where bldg_id=435)
15. , ( ). , , .
select worker_id
from "worker.db"
where not exists
(select bldg_id
from "building.db" d1
where not exists
(select *
from "assignment.db" d2
where d2.bldg_id=d1.bldg_id and d2.worker_id=worker_id))
16. min max ?
select max(hrly_rate), min(hrly_rate)
from "worker.db"