SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE Sailors (sid integer PRIMARY KEY, sname text, rating integer, age real); CREATE TABLE Boats (bid integer PRIMARY KEY, bname text, color text); CREATE TABLE Reserves(sid integer, bid integer, day date, PRIMARY KEY (sid, bid, day), FOREIGN KEY (sid) references Sailors (sid), FOREIGN KEY (bid) references Boats (bid)); insert into Sailors values (1, 'al', 4, 30); insert into Sailors values (2, 'ruv', 5, 22); insert into Sailors values (3, 'ben', 3, 55); insert into Sailors values (4, 'matt', 4, 19); insert into Boats values (1, 'SSMEOW', 'Blue'); insert into Boats values (2, 'Maven', 'Red'); insert into Boats values (3, 'Miss Cherry', 'Black'); insert into Boats values (4, 'Dawgs', 'Red'); insert into Boats values (5, 'Now', 'Red'); insert into Reserves values (1, 3, '02/19/99'); insert into Reserves values (4, 3, '03/19/99'); insert into Reserves values (4, 3, '02/12/99'); insert into Reserves values (3, 2, '02/12/99'); select * from Reserves R; Select S.”sid”, count(Br.”sid”) from Sailors S left outer join (select * from Reserves R join Boats B on (R.”bid” = B.”bid”) where B.”color” = ‘Red’) as BR on (S.”sid” = BR.”sid”) group by S.”sid”;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear