Pt1420 Unit 6

381 Words2 Pages
Problem 8 Provide a list all projects which ended on December 1, 1982. Display the year and month of the starting date and the project number. Sort the result by project number. Name the derived columns YEAR and MONTH. Result YEAR MONTH PROJNO ------------+--------------------------+------------------------ 1982 1 MA2111 1982 1 MA2112 1982 2 MA2113 ANSWER:SELECET YEAR (PRSTDATE) AS YEAR, MONTH(PRSTDATE) AS MONTH,PROJNOFROM PROJECTWHERE PRENDED = ‘1982-12-01’ORDER BY PROJNO | PROBLEM 9 List the project number and duration, in weeks, of all projects that have a project number beginning with MA. The duration should be rounded and displaed with one decimal. Name the derived column WEEKS. Order the list by the project number. Result…show more content…
Name the column containing PRENDED, ESTIMATED. Name the derived column EXPECTED. Order the list by project number. Result PROJNO ESTEMATED EXPECTED -----------------+------------------------------------+------------------------------------ MA2100 1983-02-01 1983-03-12 MA2110 1983-02-01 1983-03-12 MA2111 1982-12-01 1983-01-03 MA2112 1982-12-01 1983-01-03 MA2113 1982-12-01

More about Pt1420 Unit 6

Open Document