N Academic Tools X vecs Virginia Commi x N Case Study 4 O ITD 256 Case St x O ITD 256 Case St X M Sheila Force ((S X N Case Study 4 b My Questions b Answered: You O File | C:/Users/salyc/Downloads/ITD%20256%20Case%20Study%204%20(5).pdf ITD 256 Case Study 4 (5).pdf 3/3 13. Write a query to display the movie title, movie year, price description, and price rental fee for all movies in all categories except for family where the table name is Movies. 14. Write a query to display the minimum balance, maximum balance, and average balance for memberships that have a rental where the table name is Movies. 15. Write a query to display the rental number, rental date, video number, movie title, due date, and return date for all videos that were returned after March 15, 2018. Sort the results by rental number and movie title. The table name is Movies. 16. Write a query to display the rental number, rental date, movie title, and detail fee for each movie that was rented between the March 1, 2018 and March 31, 2018. The table name is Movies. 17. Write a query that will increase all rental fees by 10%. The table name table name is 18. Write a query that will group identical movie categories together. Movies. 19. Write a query that will show all attributes and field in the Movie table that do not contain a value. 20. Write a query that will display all movies with a return date of March 1, 2018, March 5, 2018, March 15, 2018, March 17, 2018 or March 25, 2018. Note: Do not use the OR operator for this query. Pehresor 6:34 PM O Type here to search 54 4/15/2020 17 ...

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

See similar textbooks

Related questions

Concept explainers

Question

You are not required to execute the queries. However, your syntax must by accurate.
You must give at least a one sentence explanation of each query.
You must create each query using bold italic font

need questions 13 ,14 and 15 answered

Ebaird Video is startup company providing concierge DVD kiosk service in upscale neighborhoods. Ebaird Video can own several copies (VIDEO) of each movie (MOVIE).For example, a kiosk may have 10 copies of the movie Twist in the Wind. In the database, Twist in the Wind would be one Movie, and each copy would be a Video. A rental transaction (Rental) involves one or more videos being rented to a member (MEMBERSHIP). A video can be rented many times over its lifetime. Write the SQL code for the following instances.

N Academic Tools X
vecs Virginia Commi x
N Case Study 4
O ITD 256 Case St x
O ITD 256 Case St X
M Sheila Force ((S X
N Case Study 4
b My Questions
b Answered: You
O File | C:/Users/salyc/Downloads/ITD%20256%20Case%20Study%204%20(5).pdf
ITD 256 Case Study 4 (5).pdf
3/3
13. Write a query to display the movie title, movie year, price description, and price rental fee
for all movies in all categories except for family where the table name is Movies.
14. Write a query to display the minimum balance, maximum balance, and average balance
for memberships that have a rental where the table name is Movies.
15. Write a query to display the rental number, rental date, video number, movie title, due
date, and return date for all videos that were returned after March 15, 2018. Sort the
results by rental number and movie title. The table name is Movies.
16. Write a query to display the rental number, rental date, movie title, and detail fee for each
movie that was rented between the March 1, 2018 and March 31, 2018. The table name is
Movies.
17. Write a query that will increase all rental fees by 10%. The table name
table name is
18. Write a query that will group identical movie categories together.
Movies.
19. Write a query that will show all attributes and field in the Movie table that do not contain
a value.
20. Write a query that will display all movies with a return date of March 1, 2018,
March 5, 2018, March 15, 2018, March 17, 2018 or March 25, 2018. Note: Do not use
the OR operator for this query.
Pehresor
6:34 PM
O Type here to search
54
4/15/2020
17
...

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions