عبدالله محمود الأستاذ

: Do the following steps Create a table named Sailors It contains the following columns sid number(10) primary key not null sname varchar(50) not null (rating number(10 ( age number (5 Create a table named Boats It contains the following columns bid number(10) primary key not null bname varchar(50) not null (color varchar(50 Create a table named reserves It contains the following columns ((sid number(10) primary key not null (FOREIGN KEY REFERENCES sailors(sid ((bid varchar(50) primary key not null (FOREIGN KEY (bid) REFERENCES boats(bid day datetime primary key not null Insert Data As in the picture ------------------------------------------------------------------------ selects all the columns from the "sailors" table selects only the DISTINCT values from the "sid" column in the "Reserves" table Find the names of sailors who have reserved a red boat, and list in the order of age Find the names of sailors who have reserved at least one boat Find the ids of sailors who have reserved a red boat or a green boat ' Return the names of the sailors who end with the letter 'y' Find the names of sailors who have reserved boat 103 Count the number of different sailor names Calculate the average age of all sailors Find the average age of sailors for each rating level Find the average age of sailors for each rating level that has at least two sailors