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 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%.

Name: 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 y 53392
Uploaded: 2023-11-07T22:23:26-08:00
Duration: 3 min 39 s
Channel: Akash M
Description: 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 y 53392

          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%.

Added by Julie O.

Question

Please give Ace some feedback