your submission will be the query that you would write that would return the needed result How many times has an action film been rented? How many films has ALICE STEWART rented? Which customer has rented the most times?
your submission will be the query that you would write that would return the needed result How many times has an action film been rented? How many films has ALICE STEWART rented? Which customer has rented the most times?
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Concept explainers
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
Question
your submission will be the query that you would write that would return the needed result
How many times has an action film been rented?
How many films has ALICE STEWART rented?
Which customer has rented the most times?
Transcribed Image Text:category
category_id Long:I:U
◆ last_update Date Time
◆ name VarChar(25):I
Triggers (1)
Indexes (1)
Uniques (1)
Properties (32)
▶
Triggers (1)
Uniques (1)
Properties (32)
▶
country
VarChar(50)
◆ country
country_id Long:I:U
◆last_update DateTime
▶
▶
film_category
◆ category_id Long:I
◆film_id
Long:I
last_update DateTime
Triggers (1)
Indexes (2)
Uniques (1)
Properties (32)
city
VarChar(50)
◆ city
city_id
Long:I:U
◆ country_id
Long:I
last_update Date Time
▶
▶
Triggers (1)
Indexes (1)
Uniques (1)
Properties (32)
▶
▶
▶
address
VarChar(50)
VarChar(50):N
Long:I:U
◆ city_id
Long:I
VarChar(20)
◆ district
◆last_update
Date Time
VarChar(20)
◆ phone
◆ postal code VarChar(10):N
Triggers (1)
Indexes (1)
Uniques (1)
Properties (32)
◆ address
◆ address2
address_id
▶
language
language_id Long:I:U
◆last_update Date Time
String(20)
◆ name
Triggers (1)
Uniques (1)
Properties (32)
film
◆ description
film_id
language_id
◆last_update
◆ length
Text:N
Long:I:U
Long:I
DateTime
Unsigned Long:N
original_language_id Long:I:N
◆ rating
◆ release_year
rental_duration
◆ rental_rate
rental
◆ customer_id
◆ inventory_id
◆last_update
◆ rental_date
rental_id
▶
▶
◆ return_date
◆ staff_id
replacement_cost
special features VarChar(255):N
◆ title
VarChar(255):I
Triggers (3)
Indexes (3)
Uniques (1)
Properties (32)
mpaa_rating:N
String(4):N
inventory
◆film_id
Triggers (1)
Indexes (3)
Uniques (1)
Properties (32)
◆store_id
Triggers (1)
Indexes (2)
Uniques (1)
Properties (32)
Long:I
Long:I
Date Time
Date Time
Long:I:U
DateTime:N
Long:I
Long
Double
Double
▶
Long:I
inventory_id Long:I:U
last_update Date Time
Long:I
▶
▶
▶
▶
▶
store
◆ address_id
◆last_update
◆ manager_staff_id
store_id
Triggers (1)
Indexes (1)
Uniques (2)
Properties (32)
Long:I
Date Time
Long:I:U
Long:I:U
staff
◆ active
◆ address_id
Boolean
Long:I
VarChar(50):N
◆ email
◆ first_name VarChar(45)
VarChar(45)
◆ last_name
◆last_update
Date Time
◆ password VarChar(40):N
◆ picture
Picture: N
staff_id
Long:I:U
◆store_id
Long:I
◆ username VarChar(16)
Triggers (1)
Indexes (2)
Uniques (1)
Properties (32)
▶
▶
▶
▶
▶
▶
film_actor
Long:I
Long:I
◆last_update DateTime
◆ actor_id
◆film_id
Triggers (1)
Indexes (2)
Uniques (1)
Properties (32)
payment
◆ rental_id
◆ staff_id
Triggers (1)
Indexes (3)
Uniques (1)
Properties (32)
▶
◆ amount
Double
Long:I
◆ customer_id
◆last_update
payment_date DateTime
Date Time
payment_id
Long:I:U
Long:I:N
Long:I
▶
customer
active
◆ address_id
◆ create_date
customer_id
▶
Boolean
Long:I
Date Time
Long:I:U
VarChar(50):N
◆ first_name VarChar(45)
last_name VarChar(45):I
◆ email
◆ last_update Date Time
◆store_id
Long:I
Triggers (1)
Indexes (3)
Uniques (1)
Properties (32)
▶
▶
▶
actor
actor_id
Long:I:U
◆ first_name VarChar(45)
last_name VarChar(45):I
◆last_update Date Time
Triggers (1)
Indexes (1)
Uniques (1)
Properties (32)
▶
▶
film_text
description Text:N
film_id Long:I:U
title VarChar(255)
Indexes (1)
Methods (1)
Uniques (1)
Properties (32)
▶
▶
▶
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education