Write a query to display the author ID, first name, last name, and year of birth for all authors. Sort the results in descending order by year of birth, and then in ascending order by last name AU_ID AU_FNAME AU_LNAME AU_BIRTHYEAR 185 Benson 603 Julia 438 Perry 581 Manish 218 Rachel 460 Connie 394 Robert 383 Neal 592 Lawrence 251 Hugo Reeves Palca Pearson Aggerwal Beatney Paulsen Lake Walsh Sheel Bruer 1990 1988 1986 1984 1983 1983 1982 1980 1976 1972

Write a query to display the author ID, first name, last name, and year of birth for all authors. Sort the results in descending order by year of birth, and then in ascending order by last name AU_ID AU_FNAME AU_LNAME AU_BIRTHYEAR 185 Benson 603 Julia 438 Perry 581 Manish 218 Rachel 460 Connie 394 Robert 383 Neal 592 Lawrence 251 Hugo Reeves Palca Pearson Aggerwal Beatney Paulsen Lake Walsh Sheel Bruer 1990 1988 1986 1984 1983 1983 1982 1980 1976 1972

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

Similar questions

Problem 90 Write a query to display the author last name, author first name, and book number for each book written by that author. Sort the results by author last name, first name, and then book number (Figure P7.90). (25 rows)
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.
Write a query to display the department number and most recent employee hire date for each department. Sort the output by department number (Figure P7.39).
Problem 98 Write a query to display the book number, title, and number of times each book has been checked out. Include books that have never been checked out. Sort the results in descending order by the number of times checked out and then by title (Figure P7.98).
Write a query to display the first name, last name, phone number, title, and department number of employees who work in department 300 or have the title “CLERK I.” Sort the output by last name and then by first name
The Binder Prime Company wants to recognize the employee who sold the most of its products during a specified period. Write a query to display the employee num-ber, employee first name, employee last name, email address, and total units sold for the employee who sold the most Binder Prime brand products between November 1, 2015, and December 5, 2015. If there is a tie for most units sold, sort the output by employee last name
Insert into table customerPayment, columns customerOrderld and total result set returned from query a. Select columns id and total from table customerOrder where column orderStateld is equal to subquery i. (select column id from table orderState where column state is equal to "Payment received") Write Test Case 1 as a SQL join query to do the following a. Select using concatenation of columns firstName and lastName from table www customer as Customer b. Select customerOrderId from table customerPayment as "Customer Order" c. Select description from table product as Product d. Select total from table customerOrder as “Product Total" e. Join tables customerPavment, customerOrder, customer, product f. Order by column lastName from table customer Alter table purchaseOrder add column total as data type decimal size 7,2, not null, default value of 0.0
Write a query to display the customer code, first name, and last name of all customers who have had at least one invoice completed by employee 83649 and at least one invoice completed by employee 83677. Sort the output by customer last name and then first name.