Case Study 2.2

Problem 8 Provide a list tout ensemble couchs which end on December 1, 1982. Display the family and month of the starting line appointment and the excogitate enactment. Sort the final result by project number. ca-ca the derived mainstays YEAR and MONTH. publication YEARMONTHPROJNO ------------+--------------------------+------------------------ 19821MA2111 19821MA2112 19822MA2113 wait on:SELECET YEAR (PRSTDATE) AS YEAR, MONTH(PRSTDATE) AS MONTH,PROJNOFROM PROJECTWHERE PRENDED = 1982-12-01 invest BY PROJNO| conundrum 9 List the project number and continuation, in weeks, of each(prenominal) projects that have a project number jump with MA. The duration should be rounded and displaed with one decimal. Name the derived mainstay WEEKS. shape the list by the project number. Result PROJNOWEEKS ---------------------+---------------------------- MA210056.6 MA211056.6 MA211147.7 MA211247.7 MA211341.3 ANSWER: take aim PROJNO,DECIMAL ((DAYS (PRENDATE ) * DAYS (PRSTDATE) /7.0+0.05,8,1) AS WEEKSFROM PROJECTWHERE PROJNO equal MA%ORDER BY PROJNO| Problem 10 For projects that have a project number outset with MA, list the project number, project ending date and a modified ending date assuming the projects testament be delayed by 10 percent. Name the column containing PRENDED, ESTIMATED. Name the derived column pass judgment.

Order the list by project number. Result PROJNOESTEMATEDEXPECTED -----------------+------------------------------------+------------------------------------ MA21001983-02-011983-03-12 MA21101983-02-011983-03-12 MA21111982-12-01198 3-01-03 MA21121982-12-011983-01-03 MA21131! 982-12-011982-12-29 ANSWER:SELECT PROJNO, PRENDATE AS ESTIMATED, PRSTDATE + ((DAYS (PRENDATE) * DAYS (PRSTDATE)) * 1.1) DAYSAS EXPECTED FROM PROJECTWHERE PROJNO LIKE MA%ORDER BY PROJNO| Problem 11 How many geezerhood are between the first man landing on the moon (July 20, 1969) and the first day of the year 2000? Since no columns from a specific...If you want to get a panoptic essay, order it on our website: OrderCustomPaper.com

If you want to get a full essay, visit our page: write my paper