How to find books on 'Civil War' (show their title, authors and prices) (i.e., the title field ' Civil War ') is available in' Audio 'format. * Customers (customer, name, email) * Purchase (customer, book, year) * review (customer, book, rating) * This is my schema * books (book, title, author, year) * Pricing (book, format, Value)
I did this, but did not select b.title, b.author, p.price books B, PRICING p INNER p Add books to books where WH '% mass war%' Like titles and p. Group '% AUDIO%' as format. Format, ppi
It looks like the o segment is incomplete.
Try it out:
Books from SELECT b.title, b.author, p.price, p In B iner PRPCIP P Booked = 'Bidit' WHERE b.title like '% civil war%' and p. Format like '% AUDIO%' group p. By format, PPIC At the end of the inner join, see = b.bookid? This is the problem.
Comments
Post a Comment