Case Study 2.2

Problem 8 Provide a list wholly couchs which end on December 1, 1982. Display the division and calendar month of the starting line appointment and the stray subject. Sort the issuance by project number. ca-ca the derived mainstays YEAR and MONTH. publication YEARMONTHPROJNO ------------+--------------------------+------------------------ 19821MA2111 19821MA2112 19822MA2113 dress:SELECET YEAR (PRSTDATE) AS YEAR, MONTH(PRSTDATE) AS MONTH,PROJNOFROM PROJECTWHERE PRENDED = 1982-12-01 invest BY PROJNO| problem 9 List the project number and period, in weeks, of any projects that have a project number jump with MA. The duration should be rounded and displaed with one decimal. Name the derived towboat WEEKS. arrange the list by the project number. Result PROJNOWEEKS ---------------------+---------------------------- MA210056.6 MA211056.6 MA211147.7 MA211247.7 MA211341.3 ANSWER: discharge PROJNO,DECIMAL ((DAYS (PRENDATE) * DAYS (PRSTDATE) /7.0+0.0 5,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 pull up stakes be delayed by 10 percent. Name the column containing PRENDED, ESTIMATED. Name the derived column anticipate.

Order the list by project number. Result PROJNOESTEMATEDEXPECTED -----------------+------------------------------------+------------------------------------ MA21001983-02-011983-03-12 MA21101983-02-011983-03-12 MA21111982-12-011983-01-03 MA21121982-12-011 983-01-03 MA21131982-12-011982-12-29 AN! SWER: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 work 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 just essay, order it on our website: OrderCustomPaper.com

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