Write a set of SQL statements to perform the following in the
books table below
Add a new column
books, with data type
INTEGERand no constraints.
avgPricefor each row of books to be the average price of all the books published by the same publisher. For example, if there are 3 books published by a publisher
A, with prices 300, 600 and 900 respectively, the
avgPricenext to all these books should display AVG(300, 600, 900), i.e. 600.
Note: You might have to use an UPDATE statement with a correlated subquery on the same table. Use
table aliases in the subquery for comparison with the outer statement.