dcsimg
Results 1 to 2 of 2

Thread: ask:how to make syntax from this question

  1. #1
    Join Date
    May 2009
    Posts
    1

    Question ask:how to make syntax from this question

    table sailors
    =============

    sid sname rating age
    --------------------------------------
    22 Dustin 1 45
    29 Brutus 1 33
    31 Lubber 8 55,5
    32 Andy 8 25,5
    58 Rusty 10 35
    64 Hiratio 7 35
    71 Zorba 10 16
    85 Art 3 25,5
    95 Bob 3 63,5
    74 Horatio 9 35

    table Reserves
    ==============

    sid bid day
    -----------------------
    22 101 10/10/08
    22 102 10/10/08
    22 103 10/08/08
    22 104 10/07/08
    31 102 11/10/08
    31 103 11/06/08
    31 104 11/12/08
    64 101 09/05/08
    64 102 09/08/08
    74 103 09/08/08


    table boat
    ==========

    bid bname color
    -----------------------------
    101 Interlake Blue
    102 Interlake red
    103 Chipper green
    104 Marine red


    *********************************


    create table sailors(
    sid int not null,
    sname char(20) not null,
    rating int,
    age decimal,
    constraint pk_sailors primary key(sid)
    )
    create table boats(
    bid int not null,
    bname char(10) not null,
    color char(10) not null,
    constraint pk_boats primary key(bid)
    )
    create table reserves(
    sid int not null,
    bid int not null,
    tgl datetime not null,
    constraint fk_reservesSid foreign key(sid) references sailors(sid),
    constraint fk_reservesBid foreign key(bid) references boats(bid),
    )

    insert into sailors(sid,sname,rating,age) values('22','Dustin','7','45.0')
    insert into sailors(sid,sname,rating,age) values('29','Brutus','1','33.0')
    insert into sailors(sid,sname,rating,age) values('31','Lubber','8','55.5')
    insert into sailors(sid,sname,rating,age) values('32','Andy','8','25.5')
    insert into sailors(sid,sname,rating,age) values('58','Rudy','10','35.0')
    insert into sailors(sid,sname,rating,age) values('64','Horatio','7','35.0')
    insert into sailors(sid,sname,rating,age) values('71','Zorba','10','16.0')
    insert into sailors(sid,sname,rating,age) values('74','Horatio','9','25.5')
    insert into sailors(sid,sname,rating,age) values('85','Art','3','63.5')
    insert into sailors(sid,sname,rating,age) values('95','Bob','3','35.0')

    insert into boats(bid,bname,color) values('101','Interlake','blue')
    insert into boats(bid,bname,color) values('102','Interlake','red')
    insert into boats(bid,bname,color) values('103','Clipper','green')
    insert into boats(bid,bname,color) values('104','Marine','red')

    insert into reserves(sid,bid,tgl) values('22','101','10/10/08')
    insert into reserves(sid,bid,tgl) values('22','102','10/10/08')
    insert into reserves(sid,bid,tgl) values('22','103','10/08/08')
    insert into reserves(sid,bid,tgl) values('22','104','10/07/08')
    insert into reserves(sid,bid,tgl) values('31','102','11/10/08')
    insert into reserves(sid,bid,tgl) values('31','103','11/06/08')
    insert into reserves(sid,bid,tgl) values('31','104','11/12/08')
    insert into reserves(sid,bid,tgl) values('64','101','09/05/08')
    insert into reserves(sid,bid,tgl) values('64','102','09/08/08')
    insert into reserves(sid,bid,tgl) values('74','103','09/08/08')


    how to make syntax from question below?

    1.find sailor's names that have reserve boat 103
    2.find sailor's names that have reserve red boat
    3.find sailor's names that have reserve atleast 2 boat
    4.find names and ages of sailors which rating >7
    5.find sailor's names that have reserve all the red boat

    thanks

  2. #2
    Join Date
    Oct 2005
    Location
    Ireland
    Posts
    92
    sounds like a homework question ... I wonder what would happen if I googled 'find sailors names that have reserve boat 103' ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •