Problem 64Write a query to display the book title, year, and subject for every book. Sort theresults by book subject in ascending order, year in descending order, and then titlein ascending order (Partial results are shown in Figure P7.64).BOOK TITLEBOOK YEARBOOK SUBJECTCapture the Cloud2016CloudStarlight Applications2016CloudCloud-based Mobile Applications2015CloudDatabase in the Cloud2014CloudBeyond the Database Veil2016Databasewhat You Always Wanted to Know About Database, But Were Afraid to Ask2016DatabaseDATABASES in Theory2015DatabaseMastering the database environment2015DatabaseReengineering the Middle Tier2016MiddlewareThe Golden Road to Platform independence2016MiddlewareFigure 7.64 Database SchemaThe schema for the Ch07_FACT database is shown below and should be used to answer thenext several problems. Click this image to view it in its own tab.FIGURE P7.56 THE CH07_FACT ERDCHECKOUTPATRONPKCheck NumPK Pat IDFK1 Book_NumFK2 Pat_IDCheck_Out_DateCheck_Due_DateCheck_In_Date>0-----H-Pat_FNamePat LNamePat_TypeBOOKAUTHORPKBook_NumPK Au IDBook_TitleBook_YearBook_CostBook_SubjectFK1 Pat_IDAu_FNameAu_LNameAu_BirthYearWRITESPK,FK1 Book NumPK,FK2 Au IDThe CIS Department at Tiny College maintains the Free Access to Current Technology (FACT)library of e-books. FACT is a collection of current technology e-books for use by faculty andstudents. Agreements with the publishers allow patrons to electronically check out a book,

SYNTAX The syntax for the query is as follows. SELECT column1, column2 FROM table1 ORDER BY column1 ASC, column2 DESC ; Here, column1 and column2 are retrieved from table1 and displayed. The output is sorted in the ascending order of column1 and in descending order of column2. ASC indicates ascending order while DESC indicates descending order. QUERY The final query is as follows. SELECT Book_Title, Book_Year, Book_Subject FROM BOOK ORDER BY Book_Subject ASC, Book_Year DESC, Book_Title ASC ; Three columns from the BOOK table are displayed. The output is sorted in ascending order of Book_Subject, followed by descending order of Book_Year and then ascending order of Book_Title.

Engineering

Computer Science

Write a query to display the book title, year, and subject for every book. Sort the results by book subject in ascending order, year in descending order, and then title in ascending order (Partial results are shown in Figure P7.64). BOOK, TITLE BOOK SUBJECT BOOK YEAR Capture the Cloud 2016 Cloud Starlight Applications 2016 Cloud Cloud-based Mobile Applications 2015 Cloud Database in the Cloud 2014 Cloud Beyond the Database Veil 2016 Database what You Always Wanted to Know About Database, But Were Afraid to Ask 2016 Database DATABASES in Theory 2015 Database Mastering the database environment 2015 Database Reengineering the Middle Tier 2016 Middleware The Golden Road to Platform independence 2016 Middleware Figure 7.64

Write a query to display the book title, year, and subject for every book. Sort the results by book subject in ascending order, year in descending order, and then title in ascending order (Partial results are shown in Figure P7.64). BOOK, TITLE BOOK SUBJECT BOOK YEAR Capture the Cloud 2016 Cloud Starlight Applications 2016 Cloud Cloud-based Mobile Applications 2015 Cloud Database in the Cloud 2014 Cloud Beyond the Database Veil 2016 Database what You Always Wanted to Know About Database, But Were Afraid to Ask 2016 Database DATABASES in Theory 2015 Database Mastering the database environment 2015 Database Reengineering the Middle Tier 2016 Middleware The Golden Road to Platform independence 2016 Middleware Figure 7.64

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

Q: Write a query to list the book number, title, and number of times each book has been checked out…

A: Query The query for viewing book number, title and the number of times each book had been checked…

Q: CUSTOMER aus CODE CUS LNAME CUS FNAME CuS INITIAL CUS AREACODE CuS PHONE CUS BALANCE PRODUCT P cODE…

A: SQL (Structured Query Language) is a database query language. According to ANSI, it is the…

Q: Write a query to display the author ID, first name, last name, and year of birth for all authors.…

A: A database may be defined in one of these ways it's an organized series of established facts or…

Q: Write the SQL code that counts the number of assignments ordered for each project. Call this…

A: We have four tables namely: JOB PROJECT EMPLOYEE ASSIGNMENT We wish to write a query that counts…

Q: . Write a query to display the subject and the number of books in each subject. Sort the results by…

A: SQL has a few implicit capabilities and they are called as aggregate function.SQL contains five…

Q: Using Pubs: USE MICROSOFT SQL SERVER Create a query listing all the books that Barnum’s purchased.…

A: I attached your answer below.

Q: Write a query to display the first name, last name, and email address of employees hired from May 1,…

A: Here we have to write 2 queries whose details are as follows:Write a query to display the first…

Q: Display customer number, customer name, and location for customers whose Customer_name starts with…

A: The LIKE operator is used in a WHERE clause to search for a specified pattern in a column. ORDER BY…

Q: Write a query to display the book number, title and cost of books that have the lowest cost of any…

A: Query: In general, the term query describes a question or request that is made by a user or another…

Q: using the code below write a query to display the movie title, movie year, and movie genre for all…

A: Algorithm: Retrieve and Sort Movie Information by Genre and Year1. Create a MOVIE table with…

Q: Select clause and from clause: Display the columns specified above in the problem statement from…

A: Write a query to display the author ID, first name, last name, and year of birth for all authors…

Q: Query 2: Write a query to display every member in Ohio who made a payment greater than or equal to…

A: Select (First name, Lastname) from Payment where State = "Ohio" AND Amount>=300; The above…

Q: using the code write a query to display the movie number, movie title, movie cost, and movie genre…

A: 1. Create a table named MOVIE: - Define columns: - MOVIE_NUM as INT (Primary Key) -…

Q: Write a query to display the checkout number, book number, patron ID, checkout date, and due date…

A: The query follows the syntax given below. SELECT column1, column2 FROM table1 WHERE condition ORDER…

Q: Because the SELECT clause contains the Customer* column, which clause must be included for the query…

A: Clause used in the query The SELECT statement returns a result set of records from one or more…

Concept explainers

Single Table

In a database management system, a single table is designed to obtain data of heterogeneous items. A single-table design with DynamoDB resolves the issue of raising multiple requests for the relevant data of an entity.

Question

Problem 64
Write a query to display the book title, year, and subject for every book. Sort the
results by book subject in ascending order, year in descending order, and then title
in ascending order (Partial results are shown in Figure P7.64).
BOOK TITLE
BOOK YEAR
BOOK SUBJECT
Capture the Cloud
2016
Cloud
Starlight Applications
2016
Cloud
Cloud-based Mobile Applications
2015
Cloud
Database in the Cloud
2014
Cloud
Beyond the Database Veil
2016
Database
what You Always Wanted to Know About Database, But Were Afraid to Ask
2016
Database
DATABASES in Theory
2015
Database
Mastering the database environment
2015
Database
Reengineering the Middle Tier
2016
Middleware
The Golden Road to Platform independence
2016
Middleware
Figure 7.64

Database Schema
The schema for the Ch07_FACT database is shown below and should be used to answer the
next several problems. Click this image to view it in its own tab.
FIGURE P7.56 THE CH07_FACT ERD
CHECKOUT
PATRON
PK
Check Num
PK Pat ID
FK1 Book_Num
FK2 Pat_ID
Check_Out_Date
Check_Due_Date
Check_In_Date
>0-----H-
Pat_FName
Pat LName
Pat_Type
BOOK
AUTHOR
PK
Book_Num
PK Au ID
Book_Title
Book_Year
Book_Cost
Book_Subject
FK1 Pat_ID
Au_FName
Au_LName
Au_BirthYear
WRITES
PK,FK1 Book Num
PK,FK2 Au ID
The CIS Department at Tiny College maintains the Free Access to Current Technology (FACT)
library of e-books. FACT is a collection of current technology e-books for use by faculty and
students. Agreements with the publishers allow patrons to electronically check out a book,

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 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

Based on stage 2, write queries for the following questions: Write a query to display all vendors sorted by vendor name. Write a query to display the product id, description, type, base, category, and price for all products that have a product base of water and a product category of sealer. Write a query to display the first name, last name, and email address of employees who were not hired from January 1, 2015, to December 31, 2019. Sort the output by the last name and then by the first name. Write a query to display the first name, last name, phone number, title, and department number of employees who work in department 123 and have the title “Assistant.” Write a query to display the employee number, last name, first name, salary “from” date, salary end date, and salary amount for employees 99675, 53845, and 44035. Sort the output by employee number and salary “from” date. Write a query to display the first name, last name, street no, street name, city,…
how is duplicate column prefixed when duplicate column appear in Join Query? a) Table name followed by period b) Table name followed by plus c) Table name followed by equal d) Table name followed by space abd then column name
Write a query to list the author last name, author first name and the book title and cost for each book written by the author “Xia Chiang”. Sort the result by the book title and then the costdescending
Based on the given table. Customer ID Name Balance Payment 193 Chen 2100 300 584 Ravindran 5000 250 231 Bolt 300 20 608 Gomez 950 125 What values are returned while the given query is executed? SELECT 2* (Balance - Payment) FROM Customer; 3900, 9750, 590, 1775 3600 3600, 9500, 560, 1650
Use the code below to write a query to display the movie title, movie year, and movie genre for all movies CREATE TABLE MOVIE ( MOVIE_NUM NUMBER(8,0) PRIMARY KEY, MOVIE_TITLE VARCHAR2(75) NOT NULL, MOVIE_YEAR NUMBER(4,0) CHECK (MOVIE_YEAR > 1900), MOVIE_COST NUMBER(5,2), MOVIE_GENRE VARCHAR2(50), PRICE_CODE NUMBER(2,0) CONSTRAINT MOVIE_PRICE_CODE_FK REFERENCES PRICE ); INSERT INTO MOVIE VALUES (1234, 'The Cesar Family Christmas', 2011, 39.95, 'FAMILY', 2); INSERT INTO MOVIE VALUES (1235, 'Smokey Mountain Wildlife', 2008, 59.95, 'ACTION', 1); INSERT INTO MOVIE VALUES (1236, 'Richard Goodhope', 2012, 59.95, 'DRAMA', 2); INSERT INTO MOVIE VALUES (1237, 'Beatnik Fever', 2011, 29.95, 'COMEDY', 2); INSERT INTO MOVIE VALUES (1238, 'Constant Companion', 2012, 89.95, 'DRAMA', NULL); INSERT INTO MOVIE VALUES (1239, 'Where Hope Dies', 2002, 25.49, 'DRAMA', 3); INSERT INTO MOVIE VALUES (1245, 'Time to Burn', 2009, 45.49, 'ACTION', 1);
Write a query to display the employee number, last name, first name, salary “from” date, salary end date, and salary amount for employees 99675, 53845, and 44035. Sort the output by employee number and salary “from” date.
Write a query that displays the book title, cost, and year of publication for every book in the system. Sort the results by book title.
For SQL, Table sec1611_prime_numbers contains the first 50 prime numbers. Use a self join to determine the difference between each prime and the next one.
Given a small company database tables below. Create the database and tables for the company and answer all the questions below. LINE CUSTOMER VENDOR INV_NUMBER LINE_NUMBER P_CODE LINE_UNITS LINE_PRICE Cus CODE CUS_LNAME CUS_FNAME CUS_INITIAL cus AREACODE CUS_PHONE CUS_BALANCE V_CODE V_NAME V_CONTACT V_AREACODE V_PHONE V_STATE V_ORDER 1000 3 23100-HB 0.05 10010 Ramas Afred 015 844-2573 21225 Bryson, Ine. Smithson 015 223-3234 TN 1006 4 89-WRE-Q 256.00 10011 Dunne Leona 713 804-1238 21220 SuperLoo, Inc. Flushing 04 215-8006 FL N 1 13-Q2/P2 2 14.00 1007 10012 Smith Kathy 015 804-2205 345.88 21231 DSE Supply Singh 815 228-3246 TN 1007 254778-2T 4.00 10013 Olowski Paul 815 804-2100 530.75 21344 Gomez Bros. Ortega 815 889-2546 KY N 1008 1 PVC23DRT 5.87 10014 Orlando Myron le15 222-1872 22507 Dome Supply Smith 01 e78-1419 GA IN 1008 2 WR3/TT3 3 110.05 10015 OBrian Amy 713 442-3381 23110 Randsets Ltd. Anderson 001 078-3008 GA 1008 3 23100-HB 0.05 10010 Brown James 015 297-1228 221.19 24004…
Create a PL/SQL query to display the customer’s name, employee name, donation, dispatch date and the delivery date. In your query, also display the number of days between the dispatch date and the delivery date in days for customer 11013.