Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Q2
--PostgreSQL 9.6 --'\\' is a delimiter CREATE TABLE Course (SID INTEGER NOT NULL, ClassName CHAR(30) NOT NULL, Grade CHAR(1) NOT NULL) ; INSERT INTO Course(SID,ClassName,Grade) VALUES (123,'ART123','A'), (123,'BUS456','B'), (666,'REL100','D'), (666,'ECO966','A'), (666,'BUS456','B'), (345,'BUS456','A'), (345,'ECO966','F') ; SELECT * FROM Course; SELECT ClassName, count(*) from Course GROUP BY ClassName Order by Count(*) ASC;
run
|
edit
|
history
|
help
0
FINALE fdjfnkds
Joins and Case
remove properties from jsonb using function jsonb_set of PostgreSQL
Branch
test_tags_count
Return IDs where there are exactly 3 occurrences1
Comp
base de datos api teclab
Assignment 1(SET A)
w3c sql data