Running Head: TOPIC (in caps) 1 Name Institution Date TOPIC (caps) 2 Queries Q1. SELECT UPPER(LEFT(B.TITLE,1))+LOWER(SUBSTRING(B.TITLE,2,LEN(B.TITLE))), B.PUBID, P.PUBID, P.NAME, P.CONTACT FROM BOOKS B LEFT JOIN PUBLISHER P ON B.PUBID = P.PUBID; Q2. SELECT B.ISBN, UPPER(LEFT(B.TITLE,1))+LOWER(SUBSTRING(B.TITLE,2,LEN(B.TITLE))), B.RETAIL, B.COST, B.PUBID, P.PUBID, P.NAME, ROUND(B.COST,2) FROM BOOKS B WHERE B.DISCOUNT=15% LEFT JOIN PUBLISHER P ON B.PUBID = P.PUBID; Q3. SELECT UPPER(LEFT(B.TITLE,1))+LOWER(SUBSTRING(B.TITLE,2,LEN(B.TITLE))), B.ISBN, O.ISBN AS RESULTS WHERE O.ORDER = 1014 AND ...
Purchase document to see full attachment