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

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!

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

Task 3- Views 1. 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. 2. Write a SQL statement to create a...

SQL server 2012 Products databse column names associated with this:SELECT TOP 1000 [ProductID] ,[ProductName] ,[SupplierID] ,[CategoryID] ,[QuantityPerUnit] ,[UnitPrice] ,[UnitsInStock]...

A local group of movie fanatics is working further on their review website. The group already has asked hundreds of experts to figure out which data can be extracted via SQL. Next, the group wants to...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Oracle For both Parts 1 and 2, please submit your SQL code. Submitting your output is optional. Part 1. SQL DDL (36 points) You are given a following schema: PublicChauffeurs (License Number,...

Part 1. SQL DDL (36 points) You are given a following schema: PublicChauffeurs (License Number, Renewed, Status, Status Date, Driver Type, License Type, Original Issue Date, Name, Sex, Chauffer City,...

CST 325 Homework 4 Due Date: Oct. 29, 2018 at midnight Note: Please type your solution. No late assignments will be accepted. Make sure your SQL script file can be run successfully in MySQL before...

PHP and MySQL Programming... Part 1: A Guest Book Your tasks is to create a guest book that contains three small php-scripts as follows: connect.php , which will set up a connection to the database....

Date: 16 JAN 2018 07:42:35 +0000 From: "Arnold Anderson" Subject: Apollo Shoes and Computers Darlene mentioned your inquiry earlier this week, and yes, Anderson, Olds, and...

A 2.00-kg rock is released from rest at a height of 20.0 m. Ignore air resistance and determine the kinetic energy, gravitational potential energy, and total mechanical energy at each of the...

sold at \ ( \ $ 8 5 \ ) , and sold all shares of the security. ( She promised her friend she would pay her back in a year with the same number of shares of security B ) . Then she bought security A...

Make a flowchart diagram using this programming. #include using namespace std; int main() { char name[100], email[30], phone_number[20], ic_number[20]; int number_of_guest, time_to_stay; cout

13-3 What are the principal methodologies for modeling and designing systems?

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

1. Review the discussion of business processes in Chapter 2 and Chapter 13 and the Chapter 14 discussion of IT project management and implementation. Be prepared to talk about any systems development...