mp2 - NOT NULL , `CourseName` varchar (60) NOT NULL ,...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Sheet1 Page 1 Part III 1 select sum(runningtime) as Total_Time from Movies where rating > 8 2 select title, year, rating, language from Movies where year <= 1980 and (rating >= 8 or not language = "English") 3 select title, year from Movies, Casting, Actors where lastname = "Pitt" and firstname = "Brad" and Actors.ID = Casting.ActorID and Casting.MovieID = Movies.ID 4 select concat(title, " released in ", year, " (", runningtime, "mins) with ratings ", rating) as Movies_with_Brad_Pitt from Movies, Casting, Actors where lastname = "Pitt" and firstname = "Brad" and Actors.ID = Casting.ActorID and Casting.MovieID = Movies.ID Part IV 1 create table ztan7 ( `CourseID` varchar (8)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: NOT NULL , `CourseName` varchar (60) NOT NULL , `Professor` varchar (60) NULL , `Hours` int NOT NULL , `Location` varchar (60) NOT NULL , `Grade` float (2,1) NOT NULL , PRIMARY KEY ( `CourseID` ) ) Sheet1 Page 2 2 the field CourseID, CourseName, Hour, Location, Grade will incur an error. 3 insert into ztan7 values ('Math220', 'Calculus1', 'Tom Carty', '5', 'Algebra Hall', '4.00') 4 insert into ztan7 values ( 'Fin221', 'Corporate Finance', 'NULL', '3', 'Wohlers 28', '3.7' ) insert into ztan7 values ( 'ENGL104', 'Tech. Writing', 'Slobodnik', '4', 'EB59', '4.0' ) 5 update ztan7 set Hours = 3 where courseid= &quot;ENGL104&quot;...
View Full Document

Page1 / 2

mp2 - NOT NULL , `CourseName` varchar (60) NOT NULL ,...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online