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; |
Partager