Premium Only Content
Queries with Joins and Aggregations (044)
CREATE TABLE users(
id SERIAL PRIMARY KEY,
username VARCHAR(50)
);
CREATE TABLE photos (
id SERIAL PRIMARY KEY,
url VARCHAR(200),
user_id INTEGER REFERENCES users(id) ON DELETE CASCADE
);
CREATE TABLE comments (
id SERIAL PRIMARY KEY,
contents VARCHAR(240),
user_id INTEGER REFERENCES users(id) ON DELETE CASCADE,
photo_id INTEGER REFERENCES photos(id) ON DELETE CASCADE
);
INSERT INTO users (username)
VALUES
('Reyna.Marvin'),
('Micah.Cremin'),
('Alfredo66'),
('Gerard_Mitchell42'),
('Frederique_Donnelly');
INSERT INTO photos (url, user_id)
VALUES
('https://santina.net', 3),
('https://alayna.net', 5),
('https://kailyn.name', 3),
('http://marjolaine.name', 1),
('http://chet.net', 5),
('http://jerrold.org', 2),
('https://meredith.net', 4),
('http://isaias.net', 4),
('http://dayne.com', 4),
('http://colten.net', 2),
('https://adelbert.biz', 5),
('http://kolby.org', 1),
('https://deon.biz', 2),
('https://marina.com', 5),
('http://johnson.info', 1),
('https://linda.info', 2),
('https://tyrique.info', 4),
('http://buddy.info', 5),
('https://elinore.name', 2),
('http://sasha.com', 3);
THERE IS ANOTHER INSERT INTO MISSING, CHECK THE SUBSEQUENT VIDEOS COMMENTS FOR IT.
-
1:00:32
The Dan Bongino Show
5 hours agoThe Biggest FBI Scandal In History Is Unfolding (Ep. 2395) - 01/07/2025
694K2.09K -
1:02:09
TheAlecLaceShow
4 hours agoGuest: Tim Kennedy | Cybertruck Bomber | Trump Certified | Trudeau Resigns | The Alec Lace Show
17.6K2 -
1:01:01
PMG
4 hours ago $2.12 earned"Gates Wants to Meet With Trump & Are Alternative Treatments Really Covered Up?"
20.6K11 -
LIVE
The Dana Show with Dana Loesch
2 hours agoMETA'S ZUCKERBERG ENDS FACT-CHECKING PROGRAM | The Dana Show LIVE On Rumble!
720 watching -
47:59
The Rubin Report
4 hours agoListen to ‘The View’ Crowd Gasp as Sunny Hostin Accidentally Reveals How Ignorant She Is
92.7K106 -
28:29
Grant Stinchfield
3 hours ago $1.03 earnedMeta Claims to End Censorship... This is More about Protecting Meta Than Speech!
22K7 -
1:08:56
Bare Knuckle Fighting Championship
4 hours agoThe Bare Knuckle Show with Brian Soscia
21K -
1:31:37
The Shannon Joy Show
6 hours ago🔥🔥Debt Bomb Incoming & The Bitcoin Banker Bailout. You'll Own Nothing If The Planners Succeed🔥🔥
29.8K6 -
LIVE
Sgtfinesse
4 hours agoSeason of Conquerors in 2 weeks
153 watching -
3:01:32
LFA TV
19 hours agoTRUMP LIVE PRESS CONFERENCE!! | LIVE FROM AMERICA 1.7.25 11am
52.9K25