Question
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
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