I need SQL help.  Database .txt file attached

-- Q5 (10pt) List the ten most prolific authors (full name, number of books written).
-- Q6 (10pt) List the authors (full name, number of copies) that have a number of copies in store above the average.
-- Q7 (10pt) Create a promo list for the less than $20 books (title, price, number of copies, promotional price) in which every book is discounted 50%
-- when there are at least two (2) copies in stock and not in excellent conditions (i.e. don't discount the copy in excellent conditions)
-- Q8 (10pt)List the publisher's information (code, name, city, number of books) publishers with the second most published books.

 

CREATE DATABASE HENRY;USE HENRY;CREATE TABLE Author(AuthorNum DECIMAL(2,0) PRIMARY KEY,AuthorLast CHAR(12),AuthorFirst CHAR(10) );CREATE TABLE Book(BookCode CHAR(4) PRIMARY KEY,Title CHAR(40),PublisherCode CHAR(3),Type CHAR(3),Paperback CHAR(1) );CREATE TABLE Branch(BranchNum DECIMAL(2,0) PRIMARY KEY,BranchName CHAR(50),BranchLocation CHAR(50) );CREATE TABLE Copy(BookCode CHAR(4),BranchNum DECIMAL(2,0),CopyNum DECIMAL(2,0),Quality CHAR(20),Price DECIMAL(8,2),PRIMARY KEY (BookCode, BranchNum, CopyNum) );CREATE TABLE Publisher(PublisherCode CHAR(3) PRIMARY KEY,PublisherName CHAR(25),City CHAR(20) );CREATE TABLE Wrote(BookCode CHAR(4),AuthorNum DECIMAL(2,0),Sequence DECIMAL(2,0),PRIMARY KEY (BookCode, AuthorNum) );INSERT INTO AuthorVALUES(1,'Morrison','Toni');INSERT INTO AuthorVALUES(2,'Solotaroff','Paul');INSERT INTO AuthorVALUES(3,'Vintage','Vernor');INSERT INTO AuthorVALUES(4,'Francis','Dick');INSERT INTO AuthorVALUES(5,'Straub','Peter');INSERT INTO AuthorVALUES(6,'King','Stephen');

• 1495418761-MySQL-Henry.txt

ComputerScienceExpert

(11)

Status NEW Posted 22 May 2017 02:05 AM My Price 9.00

-----------

Attachments

file 1495418763-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer