example on creating a query

[room24]

i have these tables below

create table artiste (art_id number primary key,
first_name varchar2(20),
last_name varchar2(20),
stage_name varchar2(20),
home_number varchar2(15),
cell_number varchar2(10));

create table songs (son_id number primary key,
name varchar2(50),
year number,
price number(5),
length number(3),
genre varchar2(20));


create table records_album (art_id number references artiste,
alb_id number references albums,
primary key (art_id, alb_id));

create table records_song (art_id number references artiste ON DELETE CASCADE,
son_id number references songs ON DELETE CASCADE,
primary key (art_id, son_id));


create table consists_of(alb_id number references albums ON DELETE CASCADE,
son_id number references songs ON DELETE CASCADE,
primary key (alb_id, son_id));






how would i write a query to find the name of all songs recorded by ashanti since the year 2002

 

[ceco]

SELECT s.* FROM songs AS s, artiste AS a, records_song AS rs WHERE a.first_name = 'ashanti' AND rs.art_id = a.art_id AND s.son_id = rs.son_id AND s.year >= 2002