Consider the following three tables in your working folder. Table name: OStaff Staff_ID First Name 5...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Consider the following three tables in your working folder. Table name: OStaff Staff_ID First Name 5 Mary 6 Jessica Table name: OTransaction Transaction_ID 5 7 8 Table name: Oproduct Product_ID Product_ID Product Type 2 Pastry 4 Pastry 6 Fruit 7 Drink quit; 2 4 7 Last Name Lau Moon Quantity 15 10 Product_name Cake Bread Mongo Coffee order by 2,1; 5 Price 10 9 8 Answer the following two subquestions: (a) (5 marks) State what the following query intends to achieve. (b) (30 marks) Without using SAS EG, show the result table of the following query. proc sql number; select first name, product_name, 'Attributed Sale' format=dollar4.1 20 t.quantity*p.price/count (distinct s.staff_ID) FOTW from OPRODUCT as p INE inner join otransaction as t on p.product_ID=t.product_ID, orion.ostaff s orion Consider the following three tables in your working folder. Table name: OStaff Staff_ID First Name 5 Mary 6 Jessica Table name: OTransaction Transaction_ID 5 7 8 Table name: Oproduct Product_ID Product_ID Product Type 2 Pastry 4 Pastry 6 Fruit 7 Drink quit; 2 4 7 Last Name Lau Moon Quantity 15 10 Product_name Cake Bread Mongo Coffee order by 2,1; 5 Price 10 9 8 Answer the following two subquestions: (a) (5 marks) State what the following query intends to achieve. (b) (30 marks) Without using SAS EG, show the result table of the following query. proc sql number; select first name, product_name, 'Attributed Sale' format=dollar4.1 20 t.quantity*p.price/count (distinct s.staff_ID) FOTW from OPRODUCT as p INE inner join otransaction as t on p.product_ID=t.product_ID, orion.ostaff s orion
Expert Answer:
Related Book For
Posted Date:
Students also viewed these databases questions
-
For the exclusive use of C. Tun, 2022. IIMB INDIAN INSTITUTE OF MANAGEMENT BANGALORE IMB 833 EXCEED: IMPROVING PRODUCTIVITY AND RELIABILITY IN DELIVERY OF SOFTWARE SOLUTIONS SIVAKUMAR S AND B...
-
Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...
-
Consider the following three graphs, which illustrate the preferences of three consumers (Bob, Carol, and Ted) regarding two goods, apples and peaches. Each consumer has an income of $30, and each...
-
Sketch the graph of the function. y = e -x/2
-
For each of the following populations, would a score of X = 50 be considered a central score (near the middle of the distribution) or an extreme score (far out in the tail of the distribution)? a. =...
-
Niels owned three adjoining parcels of land in Arizona. Hannah wanted to buy one. Over dinner, the two sketched and signed this agreement: "Binding Contract: Niels agrees to sell one of his three...
-
Castle Corporation operates on a calendar-year basis. It begins the annual budgeting process in late August when the president establishes targets for the total dollar sales and net income before...
-
Cupcake Queen earned net sales revenue of $67,000,000 in 2016. Cost of goods sold was $40,870,000, and net income reached $8,000,000, the companys highest ever. Compute the companys gross profit...
-
In effect since the 1970s Price of currency floats up and down daily ? Prices determined by supply and demand O Fixed exchange rates Floating exchange rates O Flexible exchange rates Supply and...
-
Will the industry generate an attractive rate of profit over this period?
-
- Week 8 - Homework: Chapter 14 Question 6 of 10 < - 12.5 View Policies Current Attempt in Progress Ayayai Company issued $648,000 of 10%, 20-year bonds on January 1, 2020, at 104. Interest is paya...
-
Describethe marketing mix (product, price, place, and promotion) and its use when planning an event. Identify and share at least 2 marketing platforms an event manager can use to gain traffic or...
-
Explore the use of nested narratives or stories-within-stories in texts like "The Canterbury Tales" by Geoffrey Chaucer or "If on a Winter's Night a Traveler" by Italo Calvino. What does this...
-
The price p (in dollars) and the demand x for a particular clock radio are related by the equation x = 5000 - 50p. (A) Express the price p in terms of the demand x, and find the domain of this...
-
Investigate the role of unreliable narration in shaping the reader's interpretation of a narrative. How does this technique challenge conventional notions of truth and objectivity in works like "The...
-
A U.S. company's foreign subsidiary had these amounts in local currency units (LCU) in 2024: Cost of goods sold Beginning inventory Ending inventory LCU 5,710,000 542,000 623,000 The average exchange...
-
explain by steps plis Coon Company uses the weighted-average method in its process costing system. The Packaging Department started the month with 300 units in process, started 1,460 units, and had...
-
The pendulum consists of two rods: AB is pin supported at A and swings only in the y-z plane, whereas a bearing at B allows the attached rod BD to spin about rod AB. At a given instant, the rods have...
-
Construct a Venn diagram representing each event. a. (not E) b. (A or B) c. (A & B) d. (A & B & C) e. (A or B or C) f. ((not A) & B)
-
The U.S. Census Bureau publishes information on the population of the United States in Current Population Reports. The following table gives the resident U.S. population, in millions of persons, for...
-
In a Zogby International Poll, conducted in early 2006 in conjunction with Le Moyne Colleges Center for Peace and Global Studies, roughly 29% of the 944 military respondents serving in Iraq in...
-
A You are required to calculate the overhead variances of Raymond Ltd. The budget is prepared as: (a) Total budgeted variable overhead \( 100,000\). (b) Total budgeted fixed overhead \( 125,000\)....
-
You are required to calculate the overhead variances from the following data. (a) Budgeted for \( 6,000\) variable overhead and 1,000 machine hours. \(\begin{array}{lr}\text { Actual overhead } & ...
-
A You are required to calculate the overhead variances in the following cases: (a) Budgeted for \( 37,000\) fixed overhead. The actual fixed overhead turns out to be \( 36,420\). (b) Budgeted for...
Study smarter with the SolutionInn App