INFS1603-Oracle-HW - Homework solutions PDF

Preview

Summary

Homework solutions...

Description

Or acl eLabExer ci ses LabWeek2 2. 3Mul t i pl eChoi ce 1.C 3.C( D) 5.B 7.C 9.D

2. 4HandsonAssi gnment 1.SELECT* FROM ZJ LB_BOOKS 3.SELECTt i t l e,pubdat eAS" Publ i c at i onDat e" FROM ZJ LB_BOOKS 5.SELECTname,c ont ac tAS" Cont actPer s on" ,phone FROM ZJ LB_PUBLI SHER 7.SELECTDI STI NCTCUSTOMER# FROM ZJ LB_ORDERS 9.SELECTl name| |' , ' | |f name FROM ZJ LB_AUTHOR 10.SELECTor der #,i t em#,i s bn,quant i t y ,pai deac h,quant i t y * pai deac hAS" I t em Tot al " FROM ZJ LB_ORDERI TEMS

2. 5AdvancedChal l enge 1.SELECTl as t name| |' , ' | |fi r s t nameAS" Name" , c i t y| |' , ' | |s t at eAS" Locat i on" ,z i p FROM ZJ LB_CUSTOMERS 2.SELECTt i t l e, ( ( r et ai l c os t ) / c os t ) * 100AS" Pr ofi t%" FROM ZJ LB_BOOKS

Or acl eLabExer ci ses LabWeek3 3. 3Mul t i pl eChoi ce 1.C 3. B 5. A 7. A 9.B 3. 4HandsonAssi gnment 1.SELECTl as t name,fi r s t name,s t at e FROM ZJ LB_CUSTOMERS WHEREs t at e=' NJ ' 3.SELECTt i t l e,c at egor y FROM ZJ LB_BOOKS WHEREc at egor y‘ FI TNESS' 5.SELECTor der #,or der dat e FROM ZJ LB_ORDERS WHEREor der dat e...