Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- NUNESGM@MYMAIL.VCU.EDU query 12 - SELECT PUBLISHER.PBID as "ID",PB_NAME as "Publisher's Name" FROM PUBLISHER WHERE not exists (SELECT 1 FROM BOOK WHERE B NUNESGM@MYMAIL.VCU.EDU 37 minutes ago
- Delete NUNESGM@MYMAIL.VCU.EDU query 11 - SELECT PBID as "ID", PB_NAME as "Publisher's Name" FROM PUBLISHER WHERE not exists (SELECT 1 FROM BOOK WHERE BK_LIST_PRI NUNESGM@MYMAIL.VCU.EDU 38 minutes ago
- Delete NUNESGM@MYMAIL.VCU.EDU query 10 - select COUNT(DISTINCT PUBLISHER.PBID) as "No of Publishers" FROM BOOK INNER JOIN PUBLISHER ON BOOK.PBID = PUBLISHER.PBID NUNESGM@MYMAIL.VCU.EDU 41 minutes ago
- Delete NUNESGM@MYMAIL.VCU.EDU query 9 - SELECT PB_NAME as "Publisher's Name",CONCAT('$',ROUND(MAX(BK_LIST_PRICE),2)) as "Max",CONCAT('$',ROUND(AVG(BK_LIST_PRICE NUNESGM@MYMAIL.VCU.EDU 41 minutes ago
- Delete NUNESGM@MYMAIL.VCU.EDU query 8 - SELECT COUNT(BKID) as "Number of Books",CONCAT('$',ROUND(MIN(BK_LIST_PRICE),2)) as "Min",CONCAT('$',ROUND(MAX(BK_LIST_PR NUNESGM@MYMAIL.VCU.EDU 48 minutes ago
- Delete NUNESGM@MYMAIL.VCU.EDU query 7 - select PUBLISHER.PBID as "ID", PB_NAME as "Name",CITY as "City",STATE as "State",PB_ZIPCODE as "Zipcode" FROM BOOK LEFT NUNESGM@MYMAIL.VCU.EDU 51 minutes ago
- Delete NUNESGM@MYMAIL.VCU.EDU query 6 - select BK_TITLE as "Title",CONCAT('$',BK_LIST_PRICE) as "List Price" , PB_NAME as "Publisher's Name",AU_NAME as "Authors NUNESGM@MYMAIL.VCU.EDU 54 minutes ago
- Delete NUNESGM@MYMAIL.VCU.EDU query 5 - select BK_TITLE as "Title",CONCAT('$',BK_LIST_PRICE) as "List Price" , PB_NAME as "Publisher's Name" FROM BOOK LEFT JOIN NUNESGM@MYMAIL.VCU.EDU 55 minutes ago
- Delete NUNESGM@MYMAIL.VCU.EDU query 4 - select BK_TITLE as "Title",CONCAT('$',BK_LIST_PRICE) as "List Price" , PB_NAME as "Publisher's Name" FROM BOOK LEFT JOIN NUNESGM@MYMAIL.VCU.EDU 56 minutes ago
- Delete NUNESGM@MYMAIL.VCU.EDU query 3 - select AU_NAME as "Name",to_char(AU_DOB,'DD MONTH YYYY') as "Date-of-Birth" FROM AUTHOR WHERE AU_DOB > DATE '1976-01-18' NUNESGM@MYMAIL.VCU.EDU 57 minutes ago
- Delete NUNESGM@MYMAIL.VCU.EDU query 2 - select AU_NAME as "Name",to_char(AU_DOB,'DD MONTH YYYY') as "Date-of-Birth" FROM AUTHOR; NUNESGM@MYMAIL.VCU.EDU 59 minutes ago
- Delete NUNESGM@MYMAIL.VCU.EDU query 1 - select AUID,AU_NAME,AU_DOB FROM AUTHOR WHERE AU_DOB > DATE '1976-01-18' NUNESGM@MYMAIL.VCU.EDU 65 minutes ago
Add Comment
Please, Sign In to add comment