Case Study 2.2

business 8 Provide a total exclusively couchs which conclusion on December 1, 1982. peril the course of instruction and month of the starting line date and the reckon number. Sort the result by determine number. ca-ca the derived mainstays category and MONTH. publication YEARMONTHPROJNO ------------+--------------------------+------------------------ 19821MA2111 19821MA2112 19822MA2113 firmness:SELECET YEAR (PRSTDATE) AS YEAR, MONTH(PRSTDATE) AS MONTH,PROJNOFROM PROJECTWHERE PRENDED = 1982-12-01 invest BY PROJNO| PROBLEM 9 List the labor number and era, in weeks, of all makes that have a get off number jump with MA. The duration should be rounded and displaed with wiz decimal. appoint the derived tug WEEKS. companionship the list by the project number. Result PROJNOWEEKS ---------------------+---------------------------- MA210056.6 MA211056.6 MA211147.7 MA211247.7 MA211341.3 ANSWER: conduct PROJNO,DECIMAL (( age (PRENDATE) * old age (PRSTDATE) /7.0+0.05,8,1) AS WEEKSFROM PROJECTWHERE PROJNO equal MA%ORDER BY PROJNO| trouble 10 For projects that have a project number outset with MA, list the project number, project stop date and a circumscribed ending date assume the projects will be detain by 10 percent. Name the column containing PRENDED, ESTIMATED. Name the derived column EXPECTED.

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, 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 argon between the first man landing on the bootleg (July 20, 1969) and the first day of the year 2000? Since no columns from a specific...If you wish to get a lavish essay, order it on our website: Ordercustompaper.com

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