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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!