1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
| /*1.1*/
select *
from CHEVAL
where RaceC like 'pur-sang anglais';
/*1.2*/
select nomp,prenomp
from PROPRIO;
/*1.3*/
select distinct c.nomc,c.racec
from CHEVAL c,PARTICIPE p
where p.Place like 1;
/*1.4*/
select distinct c.nomc as 'Nom du Cheval de plus de 2 ans',c.racec as 'Race'
from CHEVAL c
where GETDATE()-c.DateNaisC >= 2;
/*1.5*/
select pro.nomp,pro.prenomp,c.nomc
from PROPRIO pro,CHEVAL c
where GETDATE()-c.DateNaisC <= 2;
/*1.6*/
select j.nomj
from JOCKEYS j,PARTICIPE p,VERSIONCOURSE verc, COURSE crs
where j.CodeJ=p.CodeJ
and p.CodeVe=verc.CodeVe
and verc.CodeCo = crs.CodeCo
and crs.NomCo like 'grand prix d''amerique';
/*1.7*/
select c.nomc
from CHEVAL c, PARTICIPE p,VERSIONCOURSE vcrs,COURSE crs
where c.CodeC=p.CodeC
and p.CodeVe=vcrs.CodeVe
and vcrs.CodeCo=crs.CodeCo
and vcrs.DateV like '%2002-04-05%'
and crs.NomCo like '%course de la grenade%';
/*1.8*/
select c.nomc,c.codec
from CHEVAL c, PARTICIPE p,VERSIONCOURSE vcrs,COURSE crs
where c.CodeC=p.CodeC
and p.CodeVe=vcrs.CodeVe
and vcrs.CodeCo=crs.CodeCo
and crs.NomCo like '%Grand prix de bretagne%'
and p.Place <=3;
/*1.9*/
select pro.nomp, pro.prenomp,pro.PrefessionP as 'Profession'
from PROPRIO pro,CHEVAL c,VERSIONCOURSE vcrs,COURSE crs,POSSEDE p,PARTICIPE part
where pro.Codep=p.CodeP
and p.CodeC=c.CodeC
and c.CodeC=part.CodeC
and part.CodeVe=vcrs.CodeVe
and vcrs.CodeCo=crs.CodeCo
and crs.CodeCo like '%Course régionnale du s&cré coeur%'
and vcrs.DateV like '20020215'
/*1.10*/
select c.nomc
from CHEVAL c
where c.CodeC not in
( select p.CodeC
from PARTICIPE p,VERSIONCOURSE vcrs,COURSE crs
where p.CodeVe=vcrs.CodeVe
and vcrs.CodeCo=crs.CodeCo
and crs.NomCo like 'Prix de Diane');
/*1.11*/
select pro.NomP,pro.PrenomP,pro.RueP,pro.VilleP,pro.CpostalP
from PROPRIO pro
where pro.CodeP not in
(select psd.CodeP
from POSSEDE psd,CHEVAL c,PARTICIPE part,VERSIONCOURSE vcrs
where psd.CodeC=c.CodeC
and c.CodeC=part.CodeC
and part.Place <3);
/*1.12*/
select crs.NomCo
from COURSE crs, CHEVAL c,PARTICIPE part,VERSIONCOURSE vcrs
where crs.CodeCo=vcrs.CodeCo
and vcrs.CodeVe=part.CodeVe
and part.CodeC=c.CodeC
and c.NomC like '%carmont%' or c.NomC like '%three troikas%';
/*1.13*/
select crs.NomCo
from COURSE crs, CHEVAL c,PARTICIPE part,PROPRIO pro,VERSIONCOURSE vcrs,POSSEDE po
where crs.CodeCo=vcrs.CodeCo
and vcrs.CodeVe=part.CodeVe
and part.CodeC=c.CodeC
and c.CodeC=po.CodeC
and po.CodeP=pro.CodeP
and pro.NomP like 'lagardere'
and pro.NomP not like 'saint-laurent';
/*1.14*/
select count (c.CodeC) as "Nombre de chevaux de Aga Khan"
from CHEVAL c, POSSEDE p,PROPRIO pro
where c.CodeC=p.CodeC
and p.CodeP=pro.CodeP
and pro.NomP like 'Aga khan';
/*1.15*/
select count(c.CodeC) as "Nombre de chevaux"
from COURSE crs,VERSIONCOURSE vcrs,PARTICIPE part,CHEVAL c
where c.CodeC=part.CodeC
and part.CodeVe=vcrs.CodeVe
and vcrs.CodeCo=crs.CodeCo; |
