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 and last name for all authors that have never written a book with the subject Programming. Sort the results by author last name. (Figure).

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

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.

ERD:- PK CHECKOUT Check Num FK1 Book_Num FK2 Pat_ID Check Out Date Check_Due Date Check_In_Date PK BOOK Book Num Book Title Book_Year Book_Cost Book_Subject FK1 Pat_ID -H- PATRON PK Pat ID Pat_FName Pat_LName Pat_Type WRITES PK,FK1 Book Num PK,FK2 Au ID AUTHOR PK AU ID Au_FName Au_LName Au_BirthYear

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.

Problem 88 Write a query to display the patron ID, patron full name, and patron type for each patron sorted by patron ID (Figure P7.88). (50 rows)

Write a query that returns the Name of ALL Customers (based on CUS_FNAME and CUS_LNAME in CUSTOMER table, call this CUSTOMER_NAME), Phone number of ALL Customers (based on CUS_AREACODE and CUS_PHONE in CUSTOMER table, call this CUSTOMER_PHONE), for those haven’t flied before (based on the record in CHARTER table).