# Write a query to display the movie year, movie title, and movie cost sorted by movie year in descending order. (The results are shown in Figure P7.73.)

### Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482

Chapter
Section

### Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482
Chapter 7, Problem 104C
Textbook Problem
1 views

## Write a query to display the movie year, movie title, and movie cost sorted by movie year in descending order. (The results are shown in Figure P7.73.)

Program Plan Intro

Display values from table:

The contents from the table can be viewed by using “SELECT” statement which comes under Data Manipulation Language (DML). Syntax to view the contents using asterisk (*) is as follows:

SELECT * FROM table_Name;

Columns can also be retrieved by replacing all the column names in place of the asterisk symbol.

ORDER BY Clause:

SQL contains “GROUP BY” clause in order to sort rows. The values get sorted in ascending as well as descending order. The keyword used to sort values in ascending order is “ASC” and for descending order is “DESC”. By default, it sorts values by ascending order.

Syntax:

SELECT column_Name1, column_Name2 FROM table_Name ORDER BY column_Name2;

### Explanation of Solution

SQL code:

The SQL code to display movies’ titles, years and costs is given as follows.

SELECT MOVIE_YEAR, MOVIE_TITLE, MOVIE_COST FROM MOVIE ORDER BY MOVIE_YEAR DESC;

Explanation:

The above command is used to di...

### Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

#### The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Find more solutions based on key concepts
Investigate the size of the main waterline in your neighborhood. What are the inside and outside diameters? Wha...

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)

What are the three main task patterns? Provide an example of each.

Systems Analysis and Design (Shelly Cashman Series) (MindTap Course List)

What is an InfoSec framework?

Management Of Information Security

Although some routers may be able to connect more than 200 wired and/or wireless computers and mobile devices, ...

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)

If your motherboard supports ECC DDR3 memory, can you substitute non-ECC DDR3 memory?

A+ Guide to Hardware (Standalone Book) (MindTap Course List)

State the advantages of having two oxygen regulators on a machine cutting torch.

Welding: Principles and Applications (MindTap Course List)