Комментарии:
finished watching
Ответитьcreate table sailors( sid int primary key,
sname varchar(20),
rating int,
date_of_birth date);
create table boats(bid int primary key,
bname varchar(20),
color varchar(10));
create table reserves( sid int not null,
bid int not null,
dt date not null,
timeslot int,
foreign key (sid) references sailors(sid),
Tqq sir
ОтветитьSir excellent teaching .. bowing down to you sir... gratitude....Sir i have a doubt for the last question finding names of sailors who have reserved atleast one boat... correct me if am wrong sir... sir wont we get the names of the sailors if we alone join the two tables sailors and reserves because we are only going to get the names from the sailors table and if the sailors.sid is present in the reserves.sid then wont we get the names sir. do we need to mention boat table sir???.. thank you sir
ОтветитьPlease upload the next video sir
ОтветитьComplete this session as soon as possible sir
Ответитьthank you very much for the lessons and good explanation to us GOD bless you too much
ОтветитьI want this SQL queries entire playlist in separate folder.
ОтветитьIt is good
Ответить