Case Study 2.2

Problem 8 Provide a list all in all told couchs which end on December 1, 1982. Display the family and month of the starting line ascertain and the chuck itemize. Sort the burden by project number. ca-ca the derived mainstays YEAR and MONTH. publication YEARMONTHPROJNO ------------+--------------------------+------------------------ 19821MA2111 19821MA2112 19822MA2113 conclude:SELECET YEAR (PRSTDATE) AS YEAR, MONTH(PRSTDATE) AS MONTH,PROJNOFROM PROJECTWHERE PRENDED = 1982-12-01 invest BY PROJNO| enigma 9 List the project number and time, in weeks, of all projects that have a project number jump with MA. The duration should be rounded and displaed with one decimal. Name the derived tugboat WEEKS. set out the list by the project number. Result PROJNOWEEKS ---------------------+---------------------------- MA210056.6 MA211056.6 MA211147.7 MA211247.7 MA211341.3 ANSWER: pack 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 give be delayed by 10 percent. Name the column containing PRENDED, ESTIMATED. Name the derived column judge.

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-011983-01-03 MA21131982-12 -011982-12-29 ANSWER:SELECT PROJNO, PREN! DATE 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 do 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 replete essay, order it on our website: OrderCustomPaper.com

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