Question
I need help to run this program successful, how can I join the two tables? create table videos( id int not null Auto_Increment, minutes INT
I need help to run this program successful, how can I join the two tables?
create table videos( id int not null Auto_Increment, minutes INT not null, url varchar(255) not null, primary key (id) );
insert into videos (id, minutes, url) values ('5','8:10','www.youtube.com/watch?v=7zCYjI7bLOU');
insert into videos (id, minutes, url) values ('6','13:42', 'www.youtube.com/watch?v=xd4iUY1zo1E');
insert into videos (id, minutes, url) values ('7','15:36', 'www.youtube.com/watch?v=317PJUSzJRE');
insert into videos (id, minutes, url) values ('8','8:59', 'www.youtube.com/watch?v=DJS5dd8D8Hk');
insert into videos (id, minutes, url) values ('9','12:11', 'www.youtube.com/watch?v=0YY17t6hjpA');
create table reviews( id int not null auto_increment, Firstname varchar(255), Rating varchar(255) not null, shortreview varchar(255) not null, primary key (id) );
insert into reviews (firstname,id,rating, shortreview) values ('Gisselle','9','4','Ok, needed more details');
insert into reviews (firstname,id,rating, shortreview) values ('Mia','7','5','Loved it');
insert into reviews (firstname,id,rating, shortreview) values ('Lisette','6','4','Great video');
insert into reviews (firstname,id,rating, shortreview) values ('Jasmine','5','2','boring!');
insert into reviews (firstname,id,rating, shortreview) values ('Natalie','8','3','not very informative');
SELECT * FROM videos INNER JOIN reviews ON videos. = reviews.id
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started