JOINS - Filtering and Ordering

JOINs with filters - 1

Write a query to display the name and price of all books which are in the price range 100 and 600, written by a female author (gender ‘F’), and belong either to the Java course or the PHP course. Also include the name of the course and the name of the author.

The headers for the name of books, price, name of the course, and name of the author should be bookName, price, courseName and authorName respectively, and the results should be in this order.