SELECT SUM((rrprice*quantity)) AS totalprice
FROM book INNER JOIN orderdetails ON book.isbn = orderdetails.bookisbn
WHERE ono in
                           (SELECT orderno
                           FROM orders INNER JOIN bookshop ON orders.sno = bookshop.shopno
                           WHERE shopname = "Village Bookshop");