Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Subject: Relational Database With MySQL, I need help creating queries for the following: 6. Display the Authors first and last name and their Agents first

Subject: Relational Database

With MySQL, I need help creating queries for the following:

6. Display the Authors first and last name and their Agents first and last name for all Authors whose last name starts with the same first letter of your last name (if no match try the first letter of your first name but could result in no match).

7. Display the Book title and Author first and last name of the Books whose genre is either Biography or History.

8. Display the Authors first and last name, Books title and genre, Editors first and last name for all Books that are in the science fiction genre.

9. Display each Editors first and last name along with their mentors first and last name with column headers MentorFirstName and MentorLastName respectively.

10. Display the Editors first and last name, as well as the Books title sorted by Books title first and the Editors last name second for all Books that were published on September 26, 2006.

11. Display the Editors first and last name along with their ID for the Editor that has edited the most Books for Coastal Publishing.

12. Display each Authors ID, first and last names and the total number of pages for all of the Books they have written.

13. Display the Authors ID, first and last name of the Author who has the most Books in the Coastal Publishing database.

14. Display each Book genre as well as the number of Books written in that genre with the column header Number Of Books

15. Display the Authors first and last name, as well as their ID, and the Book title and number of pages for all of the books they have written that have more than the average number of pages for all of the books that have been written, listed by authors first and last name along with the book title, and the books number of pages.

___________________________________________

Here are the downloads for the setup and inserts files (If you need them)

MySQL Setup File: https://www.dropbox.com/s/2yyx1t2ntfa02xg/CoastalPublishingSetup.sql?dl=0

MySQL Inserts File: https://www.dropbox.com/s/zldaunxis6j5rf5/CoastalPublishingInserts.sql?dl=0

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

How much louder is an 80 dB noise than a 60 dB noise?

Answered: 1 week ago

Question

Describe the two-stage overhead allocation procedure.

Answered: 1 week ago

Question

What is meant by planning or define planning?

Answered: 1 week ago

Question

Define span of management or define span of control ?

Answered: 1 week ago

Question

What is meant by formal organisation ?

Answered: 1 week ago

Question

What is meant by staff authority ?

Answered: 1 week ago