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
JieShenLaiOfferSQL
Yy
Professional Networking Social Media Website SQL Analysis
SQL2_CLASS
1280. Students and Examinations
base de datos api teclab
Stack
JsonB Query
CALCULATOR USING PL/PGSQL FUNCTIONS
1225. Report Contiguous Dates