SQL Design a query to select a simple random sample of 1,000 transactions from the 120 million rows of the TRNSACT table. Specifically obtain data for the variables QUANTITY, ORGPRICE (original price), SPRICE (selling price) and AMT (QUANT * SPRICE).

One thing to understand about these transactions: There are two STYPEs, P and R. P is a purchase and R is a return. For the purpose of this query, lets restrict the sample to purchases only

Paste your SQL code here

Next, in the Answer Set tab, find the disk icon to save the query table as a Comma Separated Values (csv) format file. Then open that file in Excel and compute the mean of each column. Report your column means. Comment on the comparison among the four averages. What conclusions can you draw based on the means from your sample?

Type your response (including report of sample means)