Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Pro 2
create table sailors(id int, name char(10), rating int, age int); create table reserve(id int,bid int, day char(10)); create table boats(bid int, bname char(10), colour char(10)); insert into sailors(id,name,rating,age) values(1,'A', 2, 19); insert into sailors(id,name,rating,age) values(2,'B', 3, 28); insert into sailors(id,name,rating,age) values(3,'C', 5, 37); insert into reserve(id, bid, day) values(1,101,'17-12-2019'); insert into reserve(id, bid, day) values(2,104,'21-12-2019'); insert into boats(bid, bname, colour) values(101,'R','Blue'); insert into boats(bid, bname, colour) values(104,'K','Red'); select s.rating, avg(S.age) from sailors S group by S.rating having count (*) > 1 select s.rating, avg(S.age) from sailors S where s.age>=18 group by s.rating having count (*) > 1
run
|
edit
|
history
|
help
0
Ejercicios de SQL (I)9
Microsoft SQL Server T-SQL in 10mn ~ Lesson 15. Creating Advanced Joins samples...
a
practice sql_12AUG_Upddated
3a
Transpose group per sequence
parameters_in_procedure-join&correlated sub-query content
TestTaskSolutionByTania
Mc170404738
SQL Server Mistique!?