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. 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.Write a query to display the movie title, and movie cost sorted by movie year in descending order where the table name is Movies.Write a query to display the movie title, movie year, and movie category for all movies sorted by movie category in ascending order where the table name is MoviesWrite a query to display the movie number, movie title, and price code for all movies with a title that starts with the letter S where the table name is MoviesWrite a query to display the movie title, movie year, and movie cost for all movies that contain the word hope in the title. Sort the results in ascending order by title where the table name is Movies.Write a query to display the movie title, movie year, and movie category for all action movies where the table name is MoviesWrite a query to display the movie number, movie title, and movie cost for all movies that cost more than $40 where the table name is MoviesWrite a query to display the movie number, movie title, movie cost, and movie category for all action or comedy movies that cost less than $50. Sort the results in ascending order by movie category where the table name is MoviesWrite a query to display the movie categories and the number of movies with a category of the Action. The query must display an Alias column titled Action. The table name is Movies.Write a query to display the average cost of all the movies where the table name is MoviesWrite a query to display the movie category and average rental fee for movies in each category that have a price where the table name is Movies.Write a query to display the movie title, movie year, price description, and price rental fee for all movies that are in the categories of family and have a price greater than $10.00 where the table name is Movies.Write a query to display the movie title, movie year, price description, and price rental fee for all movies that are in the categories of family or have a price of $10.00, $15.00 or $20 where the table name is Movies in the easiest way possible. Hint: Do not use the OR operator.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.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.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.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.Write a query that will increase all rental fees by 10%. The table name is MoviesWrite a query that will group identical movie categories together. The table name is Movies.Write a query that will show all attributes and field in the Movie table that do not contain a value.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.

Question
Asked Apr 12, 2019
35 views

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.

 

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.

  1. Write a query to display the movie title, and movie cost sorted by movie year in descending order where the table name is Movies.
  2. Write a query to display the movie title, movie year, and movie category for all movies sorted by movie category in ascending order where the table name is Movies
  3. Write a query to display the movie number, movie title, and price code for all movies with a title that starts with the letter S where the table name is Movies
  4. Write a query to display the movie title, movie year, and movie cost for all movies that contain the word hope in the title. Sort the results in ascending order by title where the table name is Movies.
  5. Write a query to display the movie title, movie year, and movie category for all action movies where the table name is Movies
  6. Write a query to display the movie number, movie title, and movie cost for all movies that cost more than $40 where the table name is Movies
  7. Write a query to display the movie number, movie title, movie cost, and movie category for all action or comedy movies that cost less than $50. Sort the results in ascending order by movie category where the table name is Movies
  8. Write a query to display the movie categories and the number of movies with a category of the Action. The query must display an Alias column titled Action. The table name is Movies.
  9. Write a query to display the average cost of all the movies where the table name is Movies
  10. Write a query to display the movie category and average rental fee for movies in each category that have a price where the table name is Movies.
  11. Write a query to display the movie title, movie year, price description, and price rental fee for all movies that are in the categories of family and have a price greater than $10.00 where the table name is Movies.
  12. Write a query to display the movie title, movie year, price description, and price rental fee for all movies that are in the categories of family or have a price of $10.00, $15.00 or $20 where the table name is Movies in the easiest way possible. Hint: Do not use the OR operator.
  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 is Movies
  18. Write a query that will group identical movie categories together. The table name is 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.
check_circle

Expert Answer

Step 1

Hey, since there are multiple sub-part questions posted, we will answer first three questions. If you want any specific question to be answered then please submit that question only or specify the question number in your message.

Step 2

1.

SELECT MOVIE_TITLE, MOVIE_COST FROM MOVIE ORDER BY MOVIE_YEAR DESC;

  • Here, the “SELECT” keyword is used to select the movie title, and movie cost from the “MOVIE” table.
  • The “ORDER BY” keyword is used to sort the movie title, and movie cost by movie year in descending order.
Step 3

2.

SELECT MOVIE_TITLE, MOVIE_YEAR, MOVIE_CATEGORY FROM MOVIE ORDER BY MOVIE_ CATEGORY ASC;

  • Here, the “SELECT” keyword is used to select the movie title, movie year, and movie category...

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in

Related Computer Science Q&A

Find answers to questions asked by student like you
Show more Q&A
add
question_answer

Q: Develop the ‘Shape’ application such that: ‘Rectangle’, ‘Ellipse’, and ‘Triangle’ classes inherit f...

A: Program plan:Define a class named “Shape”.Define a default constructor to print constructor invoked ...

question_answer

Q: This is for Python code.

A: Solution:#Define functiondef twoscomp(n):       #Declare empty variable    comp = ""       #Loop exe...

question_answer

Q: CHALLENGE 1.24: Read multiple user inputs. ACTIVITY Write two scnr.nextint statements to get input v...

A: Given below is the program to get input values for month and year and write the output value as a mo...

question_answer

Q: How do I check if a binary number is a multiple of 16 by using bit shifting?

A: Approach: Result = (((n >>4) << 4) == n). First we shift the 4 bit right then we shift t...

question_answer

Q: Write a program in c++ to generate a random number between 1 - 100, and then display which quartile ...

A: Program plan:Include the required header files into the program.Define the main function.Declare the...

question_answer

Q: How would I open a file and encrypt that file from a dictionary in Python? Attached is a picture of ...

A: The functions are implemented in python 3. Since the python dictionary given in convert function is ...

question_answer

Q: Which command can you use to determine who is logged in on a specific terminal?

A: Different commands are used to determine who is logged in on a specific terminal. These commands are...

question_answer

Q: a. What are the values of i, j, k after the if statement runs?int i = 3, j = 2, k=9;if (i < j)if ...

A: The values of i, j and k for the given program are:3, 2 and 4In the program, if-else condition is th...

question_answer

Q: (The Rectangle class) Following the example of the Circle class in Section 8.2,design a class named ...

A: Note: The given program is compiled and executed in "NetbeansIDE"