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
avg with subquery
Tememons Dashboard
FINALE fdjfnkds
finaleHFEIZFIDSHI
FlujoPadre
Professional Networking Social Media Website SQL Analysis
Tic tac toe
ECommerce Website SQL Analysis by Iggy Zhao
menu sample
PostgreSQL pivot using temp view