I need help with these please. Write a SQL query against the view Author_2K13 th
ID: 3819333 • Letter: I
Question
I need help with these please.
Write a SQL query against the view Author_2K13 that includes the Name and Date-of-Birth only for each Author born after June 30, 2014. Grant the user Abena the privilege to display (i.e. SELECT) the PBIP, PB_NAME, PB_STREET, PB_ZIPCODE & PB_PHONE for each Publisher whose PB_ZIPCODE is 23284 or 23285 only. Also grant her the privileges to INSERT and DELETE records for each Publisher whose PB_ZIPCODE is 23284 or 23285 only. Write a SQL query that will list the BK_TITLE, BK_LIST_PRICE, PB_NAME for those Books whose BK_LIST_PRICE is less than $250.00 and the corresponding PB_ZIPCODE is 23284 or 23285. Grant the user Abena the privilege to display (i.e. SELECT) the BK_TITLE, BK_LIST_PRICE, PB_NAME for those Books whose BK_LIST_PRICE e is less than $250.00 and corresponding PB_ZIPCODE is 23284 or 23285.Explanation / Answer
-- #6.
SELECT NAME,DATE_OF_BIRTH FROM AUTHOR_2K13
WHERE DATE_OF_BIRTH > TO_DATE('30-06-2014','DD-MM-YYYY');
-- #7.
--SELECT
SELECT PBID,PB_NAME,PB_STREET,PB_ZIPCODE,PB_PHONE
FROM PUBLISHER
WHERE PB_ZIPCODE IN (23284,23285);
--DELETE
DELETE
FROM PUBLISHER
WHERE PB_ZIPCODE IN (23284,23285);
-- #8.
SELECT BK_TITLE,BK_LIST_PRICE,PB_NAME
FROM BOOKS
WHERE BK_LIST_PRICE < 250
AND PB_ZIPCODE IN (23284,23285);