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. I need all questions and parts 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.   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. Write a query to display the movie title, movie year, and movie category for all action movies where the table name is Movies 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 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 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. Write a query to display the average cost of all the movies where the table name is Movies 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. 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 Movies Write 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

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.

I need all questions and parts 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.

 

  1. 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.
  2. Write a query to display the movie title, movie year, and movie category for all action movies where the table name is Movies
  3. 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
  4. 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
  5. 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.
  6. Write a query to display the average cost of all the movies where the table name is Movies
  7. 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.
  8. 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.
  9. 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.
  10. 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.
  11. 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.
  12. 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.
  13. 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.
  14. Write a query that will increase all rental fees by 10%. The table name is Movies
  15. Write a query that will group identical movie categories together. The table name is Movies.
  16. Write a query that will show all attributes and field in the Movie table that do not contain a value.
  17. 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.
 

 

Expert Answer

1 Rating

Want to see the step-by-step answer?

See Answer

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

See Answer
*Response times vary by subject and question complexity. Median response time is 34 minutes and may be longer for new subjects.

Related Computer Science Q&A

Find answers to questions asked by student like you

Q: 5-13) Find the largest n such that n cubed is less than a positive integer entered by the user. Use ...

A: The heart of the algorithm lies in finding such a number whose cube is less than the given number he...

Q: Convert the grammar S → aSb|Sab|ab into Chomsky normal form.

A: Solution:Chomsky Normal Form (CNF):The Chomsky normal form is a content-free grammar when each and e...

Q: in eclipse

A: In operator overloading, the type of arguments defines which function will be called at the run-time...

Q: how can I write a statement in C++ that would print last name, followed by a comma, followed by firs...

A: Given below is the C++ program to print a statement with last name, followed by comma, followed by f...

Q: how to put a picture to top right corner in HTML

A: HTML stands for Hypertext markup language and is mainly used to format web pages and web sites. Html...

Q: Rainfall StatisticsWrite a program that lets the user enter the total rainfall for each of 12 months...

A: The following program is in C++ language and it is compiled in the “repl.it” compiler.Program plan:I...

Q: Consider the following segment of code:procedure Mvar x: integer;procedure A (c: integer)var a, b: i...

A: Instructions for drawing the runtime stack (at “a:= c-d;”):The stack includes the activation records...

Q: Give regular expressions for the following languages. (a) L1 = {anbm, n ≥ 3, m ≤ 4} (b) L2 = {anbm :...

A: Answer:Regular expression:a. L = {an bm, n >=3, m <= 4}

Q: For problem 10RQ for Business Informaiton Systems book by Paige Baltzan, the question asked what is ...

A: The terms Collective intelligence, Knowledge management and Crowdsourcing are related to each other ...