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
Many to many
2
Laidata Practice
2
test 16721723
tegs and users
librarayv2
Pivot the Hard Way..
loggin_trigger-audit
project 1