_a collection of individual query scripts to execute as a minimum the following queries: (I need sql plus oracle codes for each question alone)

1- Develop an SQL query to show all the details of paintings such as painting's name, theme, owner's name, owner phone number which are availble for hire sort by the owner's name.?

2- Develop a query to display all the artist's details with their paintings, sort by the artist's name, then by the painting's name.?

3- Develop a query to show all the painting's which are hired for a partiod. The details such as the painting's names, owner's names and customer' names need to be displayed.?

4- Develop a query to list the customers in the platinum and gold category, who rented the paintings.?

5- develop a query to list the painting's name, the owner's name, and the monthly rental rates of all the paintings, sorted by the monthly rental rate.??

these are tables:

Table Costumer	Type Attribute	Key
CustID CustName CustPhone CustLocation CustEmail BrCode CuCa_ID	Int Varchar2(20) Number(13) Varchar2(15) Varchar2(30) Int Int	PK FK FK
Table Branch	Type Attribute	Key
BrCode BrNumber BrPhone BrLocation	Int Number(8) Number(12) Varchar2(15)	PK
Artists	Type Attribute	Key
ArtID ArtName ArtPhone ArtEmail ArtLocation BrCode	Int Varchar2(20) Number(15) Varchar2(25) Varchar2(15) Int	PK FK
Paint Rental	Type Attribute	Key
PntRe_ID PntRe_Price PntRe_Customer PntRe_Location PntRe_StartDate PntRe_EndDate ArtId	Int Number(12) Varchar2(20) Varchar2(15) Date Date Int	PK FK
Owners	Type Attribute	Key
OnrID OnrName OnrLocation OnrPhone OnrEmail PntID	Int Varchar2(20) Varchar2(15) Number(12) Varchar2(25) Int	PK FK
Painting	Type Attribute	Key
PntID PntPrice PntQuantity Pnt_Rental_Permanth ArtID	Int Number(12) Number(15) Number(15) Int	PK FK
Customer Categories	Type Attribute	Key
CuCa_ID CuCa_Name CuCa_Discount	Int Varchar2(20) Number(12)	PK