Please show the step by step process with pictures and detail 4. BookFinder.com
ID: 3815293 • Letter: P
Question
Please show the step by step process with pictures and detail
4. BookFinder.com BookFinder.com is an open marketplace for books online, a one-stop e-commerce search engine where you can search through more than 100 million new, used, rare, and out-of-print books for sale. The site is produced by a team of high-tech librarians and programmers, working since 2004 to connect readers with the books they are looking for. They are part of their own audience; members of the BookFinder.com team are heavy readers and buy several dozen books every year using BookFinder.com. They also blog about their work, connecting read ers and booksellers from around the world and supporting public access to a strong, di- verse bookselling industry.Explanation / Answer
Authors Query:
SELECT FirstName,LastName,title,price,category
FROM Authors A INNER JOIN Books B
ON A.AuthorID=B.AuthorID INNER JOIN Categories C
ON B.CategoryID=C.CategoryID
Where CategoryName = 'Novel' AND price > $10.00
Book Prices Query:
ORDER BY price
Min Book Price Query:
SELECT MIN(Price) AS SmallestPrice
FROM Books;
Less 50 cents Query: