Questions answered:
-
How much money is spent for what purpose by consumers in the U.S. in the first quarter of 2010 ? Another way to phrase this is : What is the personal consumption expenditure of each function in the first quarter of 2010 ? The result should have the columns: func, pce.
-
Which function, year, and quarter has the smallest PCE of all time? The result should have the columns: func, year, quarter, pce.
-
What is the function (and the corresponding PCE) that consumers spent the most money on in the first quarter of 2010 ? The result should have the columns: func, pce.
-
What is the annual PCE for each function ? The result should have the columns: func, year, annualpce.
-
What is the function, year, and PCE with the most annual PCE ? The result should have the columns: func, year, annualpce.
-
Which year has the largest total PCE ? (Use the pcefunc table for this question). The result should have the columns: year, annualpce.
-
What is the total PCE for each level two product in the year 2009 ? The result should have the columns: prodlevel2, totalpce.
-
What is the annual PCE of “Goods” for each year ? The result should have the columns: year, annualpce.
Example to load using docker:
sqlplus (default password: oracle, username not requested)
CREATE USER 1 IDENTIFIED BY 1;
GRANT CONNECT TO 1;
GRANT CREATE SESSION GRANT ANY PRIVILEGE TO 1; (new user login is now username: 1 pass: 1)?
apt wget install (install wget to obtain zip file)
unzip dockerfilename.zip (to unzip zip file on docker)
-------------------------------------------------------