Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write a SQL statement to find the Comedy films with the longest running time. Your query should output the names and lengths of the films.

Write a SQL statement to find the Comedy films with the longest running time. Your query should output the names and lengths of the films.

CREATE TABLE category ( category_id NUMBER(3) NOT NULL, name varchar2(25) );

CREATE TABLE film ( film_id NUMBER(5) NOT NULL, title varchar2(255), description varchar2(255), release_year NUMBER(4) DEFAULT NULL, language_id NUMBER(3) NOT NULL, original_language_id NUMBER(3) DEFAULT NULL, rental_duration NUMBER(3) DEFAULT 3 NOT NULL, rental_rate NUMBER(4,2) DEFAULT '4.99', length NUMBER(5) DEFAULT NULL, replacement_cost NUMBER(5,2) DEFAULT '19.99' NOT NULL, rating varchar2(8) DEFAULT 'G', special_features varchar2(255) DEFAULT NULL );

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_2

Step: 3

blur-text-image_3

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

Spatial Database Systems Design Implementation And Project Management

Authors: Albert K.W. Yeung, G. Brent Hall

1st Edition

1402053932, 978-1402053931

Students also viewed these Databases questions

Question

What is the general purpose of preliminary screening?

Answered: 1 week ago

Question

13-4 What are alternative methods for building information systems?

Answered: 1 week ago