[IMG http://img.photobucket.com/albums/v475/MR7/tabelas.jpg[/img]
Based on it, I set it up here:
create table CD
(codigo number(5) not null,
nome varchar2(50) not null,
dataCompra date not null,
valorPago number(5,2),
localCompra varchar2(50),
album varchar2(50),
constraint pk_cd primary key (codigo));
create table Musicas
(codCD number(5) not null,
numero number(2) not null,
nome varchar2(50) not null,
artista varchar2(50) not null,
tempo date not null,
constraint pk_musicas primary key (codCD, numero),
constraint fk_musicas foreign key (codCD) references CD (codigo));
to_date('05:22','mi:ss')
h) Show the total time of songs registered.
j) Show the total time of songs per CD.
L) Show the average duration of the songs registered.
And that's what I need to do, I have to manipulate this data I entered to answer these questions, but it's very complicated, I tried everything I'vê learned so far and I could not solve it. Thanks anticipated for help, sorry for the huge amount of text. Thanks ... \ o