Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Leetcode 571 Find Median Given Frequency of Numbers & 614 Second Degree Follower
--PostgreSQL 9.6 --'\\' is a delimiter drop table if exists Numbers; Create table Numbers ("Number" int, "Frequency" int); insert into Numbers ("Number", "Frequency") values (0, 7), (1, 1), (2, 3), (3, 1); drop table if Exists follow; create table follow ("followee" varchar(255), "follower" varchar(255)); insert into follow ("followee", "follower") values ('A', 'B'), ('B', 'C'), ('B', 'D'), ('D', 'E');
run
|
edit
|
history
|
help
0
3c
PostgreSQL pivot using temp view
Q4_2
Movie Rating SQL Analysis Project
Many to many
Laidata Practice
Leetcode 569. Median Employee Salary
Pivot the Hard Way.
1
1075-1077 Project Analysis