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
-
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. =...
-
A tank of area Ao is draining in laminar flow through a pipe of diameter D and length L, as shown in Fig. P4.92. Neglecting the exit-jet kinetic energy and assuming the pipe flow is driven by the...
-
Sketch curves to scale of momentum for the collision of object A initially moving with velocity \(v\) and object B initially at rest, for the following cases: (a) \(m_{A}=m_{B}\), (b) \(m_{A}=2...
-
Summary information from the financial statements of two companies competing in the same industry follows. Required 1. For both companies compute the (a) Current ratio, (b) Acid-test ratio, (c)...
-
All work must be shown on every facet of the solution. This includes a timeline with cashflows, timing and rates clearly laid out and formulas (in pure form, not in the calculator or excel form). A...
-
Graph the equation y=-x^(2)+6x-8 on the accompanying set of axes. You must plot 5 points including the roots and the vertex. Using the graph, determine the equation of the axis of symmetry. Click to...
-
Chevalier de Mr used to bet that he could get at least one 6 in four rolls of a die. He also bet that, in 24 tosses of a pair of dice, he would get at least one 12. He found that he won more often...
-
Suppose you are given two urns, numbered Urn I and Urn II. Contents of Urn I: 5 red, 6 blue, and 10 green marbles Contents of Urn II: 30 red, 20 blue, and 10 green marbles The probability of...
-
In the game of Problem 57, what is the probability that there will be an odd man out in a particular play if there are five players? Data from Problem 57 In a certain office, three men determine who...
-
Find the probability of obtaining exactly three heads on five tosses of a fair coin.
-
What is a binomial random variable?
-
A box contains 3 blue and 4 red marbles while another box contains 2 blue and 5 red marbles. A marble drawn at random from one of the boxes turns out to be blue. What is the probability that it came...
-
Controls can be identified based on their function. The functions are preventive, detective, and corrective. A. True B. False
-
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 uniform circular wire of radius \(R\) is forced to rotate about a fixed vertical diameter at constant angular velocity \(\omega\). A bead of mass \(m\) experiences gravity, is smoothly threaded on...
-
Two point masses \(m\) and \(M\) are connected by a massless rod of length \(\ell\) and placed on a horizontal table. The mass \(m\) is also connected to a fixed point \(P\) on the table by a spring...
-
(a) Show that the relativistic Lagrangian \(L=-(1 / \gamma) m c^{2} e^{U / c^{2}}\) reduces to the Newtonian Lagrangian for a particle of mass \(m\) in a gravitational potential \(U\) in the slow...
Study smarter with the SolutionInn App