Question: Given table: Author: (ID, LastName, Name, PostCode) writings: (Author.ID, Book.ISBN, Stock, singlepayment, comment) Book: (ISBN, Title, Price, noOfPages) create an SQL statement to show: which

Given table:

Author: (ID, LastName, Name, PostCode)

writings: (Author.ID, Book.ISBN, Stock, singlepayment, comment)

Book: (ISBN, Title, Price, noOfPages)

create an SQL statement to show: which id of author who has written the longest pages (noOfPages)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Here is the script given: Looking for the answer to the Advanced Challenge Quetion. CREATE TABLE warehouses (wh_id NUMBER(2), location VARCHAR(12) ); INSERT INTO warehouses VALUES (10, 'Boston');...

Q:

A SQL script is a set of SQL commands saved as a SQL file. If you are already running MySQL, you can execute a SQL script file using the source command or you can import it in Workbench. Write an SQL...

Q:

Please use SQL Developer to write the queries below. Copy and paste your query code into the submission box for this assignment. This assignment should be completed by October 5. Write a query that...

Q:

You will have the following classes: Book POJO Class attributes: isbn, title, editionNumber, copyright Methods: constructor, get methods, toString Author POJO Class attributes: authorId, firstName,...

Q:

Unit 6 Lab - SQL statements - Need help on these CIS 338: SQL/Oracle Learning Unit 6: Lab Activity Lab Activity Complete the following SQL exercises using the JustLee Books database. Launch Oracle...

Q:

Using SQL Developer execute the following queries with these statements. N eed help with the joining clauses in SQL. PLEASE help Write a query to display the title, publisher name, and author FROM...

Q:

This is the bookstore.sql: DROP TABLE CUSTOMERS CASCADE CONSTRAINTS; DROP TABLE ORDERS CASCADE CONSTRAINTS; DROP TABLE PUBLISHER CASCADE CONSTRAINTS; DROP TABLE AUTHOR CASCADE CONSTRAINTS; DROP TABLE...

Q:

Read the instructions To perform these assignments, refer to the tables shared in p: Drive. tables to share.txt that is shared in the drive P:\viji\week 9\tables to share.txt. Generate and test two...

Q:

Unit 6 Lab - SQL statements - Need help on these CIS 338: SQL/Oracle Learning Unit 6: Lab Activity Lab Activity Complete the following SQL exercises using the JustLee Books database. Launch Oracle...

Q:

Unit 3 Assignment - SQL statements - Please be aware that I am using APEX.ORACLE.com and the SQL command statement must run successfully without errors. 1. Which orders shipped after April 1, 2009?...

Q:

Assume that the following current asset and current liability accounts apply to the Harden Company for the years 2020 and 2021 (note: the ??? in the table is a figure that you must determine). Hardin...

Q:

Brewster Company produced 1,500 units of product that required 1.5 standard hours per unit. The standard variable overhead cost per unit is $1.70 per hour. The actual variable factory overhead was...

Q:

Insert a subtotal for each change in area for the total book sales

Q:

last two options for the multiple choice are : performance management development A construction equipment manufacturer, Roswell Corporation, is focusing on becoming a leader in sustainability in...

Q:

III. What will be on the new SlickBoards Web site? A. Outline all the new information about the products that will be on the Web site and how it will increase sales B. Explain how clients will be...

Q:

II. Why do we need a new SlickBoards Web site? A. Overview of our current Web site and its deficiencies B. Present the concept of the new Web site, why we needed a revamp, and how it improves on the...

Q:

How do you feel about group meetings? Do you find them energizing, boring, a waste of time? Consider an effective meeting and an ineffective meeting that youve attended. To what degree did the...