Search for question
Question

1. Show all publishers not in the USA.

2. What amount does each publisher pay in royalties?

3. Show all titles published in October of 1991

4. What is the average number of books sold in each store?

5. Show all orders placed before March of 1993

6. Show the publisher's name that published the highest number of titles.

7. Based on the sales table, show each store's first sale date./nYour answers should include sql query and paste the results (outcome) in your work.

titleauthor

au_id

title_id

au_ord

royaltyper

titles

title_id

title

type

pub_id

price

advance

royalty

ytd_sales

notes

pubdate

authors

au_id

sales

Pubs DB data model

au_Iname

au_fname

phone

address

authors

ure

zip

contract

stor_id

ord_num

ord_date

qty

payterms

title_id

publishers

pub_id

pub_name

city

state

country

stores

stor_id

stor_name

stor_address

city

state

zip

pub_info

pub_id

logo

pr_info

Fig: 1

Fig: 2