Question: Write a program in python to run the following functions in order: 4 . Find the publisher who has published the most titles. If 2

Write a program in python to run the following functions in order: 4. Find the publisher who has published the most titles. If 2 or more publishers are
tied for the most number of titles, then your program should print all of them.
4. Find the publisher who has published the most titles. If 2 or more publishers are
tied for the most number of titles, then your program should print all of them.
5. List all the authors and the total price of their published titles, in order of greatest
to least total price. If an author has no published titles, they do not need to be listed.
6. Find the names of all titles which have more than 1 author who wrote it.
7. Find the names of all publishers who have published a book with a price below
$500, with a cover type of Paper Back.
8. Write a query to retrieve the names of all authors who have written books whose
subjects contain the word JAVA, but have not written any books on the subject
VISUAL BASIC.NET.
9. Write a query to retrieve the names of all publishers whose email addresses
contains the domain .com.
10. Form a query to decrease the price of all books published before 2003 by 5%
and increase the price of all books published after 2004 by 15%.

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 Finance Questions!