1Report the Artist Name and the average UnitPrice per artist

1.Report the Artist Name and the average Unit_Price per artist in oracle sqldeveloper query ,

Solution

Hi Friend, you have not given the details of Schema.

But based on the inforamtion given in question, Please find my query

select Artist_Name, sum(Unit_Price)/count(Artist_Name) as \'average Unit_Price\'
   from productos
   group by Artist_Name