Answer to Question #200403 in Databases | SQL | Oracle | MS Access for M RAMUHULU

Question

Write SQL code that create a report that ask the user to enter publisher’s name in any case and in any form (entering full name or part there of) and it must retrieve all the books details published by this specific publisher. It must display isbn, title, author name, date published, total copies, total price.

 

Important Facts:     

✓ Page width must be 132 and page length 19

✓ The code must not display the number of records retrieved and it must not verify the value entered. ✓ Reset all the format that you created

✓ Use local currency for prices

✓ Negative marking will apply if columns aliases are used within the query statement. 

Answer 1

select publisher_name

from Publisher natural join Copies natural join natural join Dates natural join Price natural join Title;

where publisher_name as  input.publisher;