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