Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
book suggestion
--PostgreSQL 9.6 --'\\' is a delimiter create table user_bk_his( user_id text, book_id text); insert into user_bk_his values ('U1','B1'); insert into user_bk_his values ('U1','B2'); insert into user_bk_his values ('U2','B1'); insert into user_bk_his values ('U2','B2'); insert into user_bk_his values ('U2','B3'); insert into user_bk_his values ('U3','B2'); insert into user_bk_his values ('U3','B3'); insert into user_bk_his values ('U4','B7'); insert into user_bk_his values ('U5','B1'); insert into user_bk_his values ('U6','B1'); insert into user_bk_his values ('U6','B2'); insert into user_bk_his values ('U6','B3'); insert into user_bk_his values ('U7','B1'); insert into user_bk_his values ('U7','B2'); insert into user_bk_his values ('U7','B3'); insert into user_bk_his values ('U8','B1'); insert into user_bk_his values ('U8','B2'); select book_id, count(user_id) from user_bk_his where book_id <> 'B1' and user_id in (select distinct user_id from user_bk_his where book_id = 'B1') group by book_id having count(user_id) > 1 order by count(user_id) desc
run
|
edit
|
history
|
help
0
Atuação
SQL - Social Network Analysis by Patrick Lin
FInale 38474297439
SQL - Unpivot Table
1280. Students and Examinations
1075-1077 Project Analysis
Count total records
Return IDs where there are exactly 3 occurrences
Limit & union
Professional Networking Social Media Website SQL Analysis