Oracle Sql

Task 0:

Run bookstore.sql to create and populate tables:

Author(a_name, gender, age, nationality)

Book(isbn, title, ver_no, publisher)

Writtenby(isbn, a_name, yr_published, price, no_copy)

Task 1:

1. Write a procedure that saves the income made by a given author, display the income in an anonymous block

1.2 Create an anonymous block to show income made by each author, use the procedure created in task 1.

Task 2:

Write a function that returns how old a book is

Published before 2000 ->Book X by author Y is an old book

Between 2000 and 2020 -> Book X by author Y is modern

2020 and later -> Book X by author Y is recently published

X: book name

Y: author name

Task 3:

Without using max write a function to return the published with highest number of book copies published

Print: X publisher has published N copies of book and made M income