List the type and the average price


Discuss the below:

Use SQL to complete the following:

For each type of book, list the type and the average price. There are several BOOKs in each type. 

For example, this is what it should look like:

TYPE

AVG(PRICE)

TRA

10.50

SFI

11.25

SCI

5.50

PSY

21.25

POE

16.50

PHI

8.00

MYS

17.20

HOR

12.28

HIS

12.00

FIC

18.50

CMP

10.00

ART

30.25

Solution Preview :

Prepared by a verified Expert
PL-SQL Programming: List the type and the average price
Reference No:- TGS01939250

Now Priced at $20 (50% Discount)

Recommended (98%)

Rated (4.3/5)