Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
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
Please
log in
to post a comment.
1097. Game Play Analysis V
Assignment 1(SET A)
a
univesp
Correlated subquery in SELECT clause, and rewritten for Netezza
podd version
Query for matching substring from text field in DB
Shortest "path" between two employees across companies
Codigo_Completo
Assignment
Please log in to post a comment.