Need sql command line code What is the average royalty per book for the titles i

Question

Need sql command line code

What is the average royalty per book for the titles in ROYALTY_SCHEDULE?

SQL> desc service_request

Name                                      Null?    Type

----------------------------------------- -------- -----------------------

SERVICE_ID                                NOT NULL NUMBER(4)

SLIP_ID                                            NUMBER(4)

CATEGORY_NUM                                       NUMBER(4)

DESCRIPTION                                        CHAR(255)

STATUS                                             CHAR(255)

EST_HOURS                                          NUMBER(4,2)

SPENT_HOURS                                        NUMBER(4,2)

NEXT_SERVICE_DATE                                  DATE

Explanation / Answer

select book, AVG(royalty) from <table_name> where title='ROYALTY_SCHEDULE' group by book;

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.