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
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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
