tornament_sponsors matches tornaments_id INT(11) sponsors sponsor_jid INT(11) tornaments id INT(11) player jd_1 INT(11) player id_2 DNT(11) Oresult_code INT(1) O start date DATE O end_date DATE...

Find and display what type of rank players played in a tournament organized by omer

khalid.
Q#5 Print the name of the players and email who have started matches in 2002,2003 and 2004.
(Nested queries

Extracted text: tornament_sponsors matches tornaments_id INT(11) sponsors sponsor_jid INT(11) tornaments id INT(11) player jd_1 INT(11) player id_2 DNT(11) Oresult_code INT(1) O start date DATE O end_date DATE sponsor_id INT(11) Indexes O sponsor_name VARCHAR(12) O sponsor_phone INT(11) O address_id INT(11) Indexes ) tornaments P tornaments_id INT(11) organizer_id INT(11) players Indexes P player_jd INT(11) O fram e VARCHAR( 12) -HHolname VARCHAR( 12) O tornament start date DATE O adress jd VARCHAR(12) O phone_number VARCHAR(11)| |O email VARCHAR(12) | player_participated ▼ | •player_jd INT(11) otormaments id INT(11) Indexes O tornament end_date DATE --+ o tornament_nam e VARCHAR(12) O winer id INT(11) Indexes dub_id INT(11) rank_code INT(11) result_codes Presult code INT(1) Oresult description VARCHAR(12) Indexes | rank_code P rank_code INT(11) Orank descripton VARC. Indexes Indexes | tornament_organizer P organizer id INT(11) O dub jd INT(11) -K organizer_name VARCHAR(12) | chessclub P dub_jid INT(11) O dub_name VARCHAR(12) dub_owner VARCHAR(12) O adress id VARCHAR(30) ) address O organizer_phone_num ber INT(11) 1 adress id VARCHAR(12) O ciy VARCHAR(12) O street_rumber INT(11) O house_number INT(11) O organizer_address VARCHAR( 15) Indexes Indexes Indexes Import chess_final.sql schema.