Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Professional SQL Server 2012 Internals And Troubleshooting

Authors: Christian Bolton, Justin Langford

1st Edition

1118177657, 9781118177655

More Books

Students also viewed these Databases questions