Use SQL produce sample output from your database for the following: Use SQL to find the Donor
Fantastic news! We've Found the answer you've been seeking!
Question:
Use SQL produce sample output from your database for the following: Use SQL to find the Donor category contributions by program for the third quarter
Transcribed Image Text:
Figure 5-1 Quarterly Campus Targets 202X Individual Campus Targets (Thousands of Dollars) Qtr 2 Qtr 1 400 200 Main Campus Kennedy Campus Langley Campus 75 Goddard Campus 100 The data items introduced in Figure 5-1 are the following: 400 250 100 100 1. Mars Research Program (MRP) 2. Venus Research Program (VRP) 3. Saturn Research Program (SRP) 4. Jupiter Research Program (JRP) Qtr 3 500 250 125 150 1. CAMPUS: a 6-character alphanumeric field to designate each campus of the research center. Qtr 4 600 300 150 150 2. QUARTERLY TARGETS: four numbers indicating the quarterly targets (in thousands of dollars) needed for each campus. This is a 10-digit numeric field including two decimal places. An additional outcome from the interviews discussed above was the identification of categories of programs that needed funds. The following categories were identified: Page 2 of 11 Committee members were assigned specific programs and specific types of donors on the basis of the members' preferences and abilities. Armstrong felt that such an approach would make it possible for the committee members to interact with existing and potential donors in a more professional manner. THE DONORS An examination of existing records identified a set of significant donors (expected annual contributions exceeding $50,000 each). This was done for a number of reasons. First, explicitly identifying such donors would enable the committee to pursue them specifically for contributions. Second, given these donors prior contributions and information from meetings with them, a projection of expected contributions for the current year could be made. This would allow for better planning by the research center for the disbursement of funds to specific programs and campuses. Third, committee members could be more appropriately assigned to pursue specific significant donors. Figure 5-1 Quarterly Campus Targets 202X Individual Campus Targets (Thousands of Dollars) Qtr 2 Qtr 1 400 200 Main Campus Kennedy Campus Langley Campus 75 Goddard Campus 100 The data items introduced in Figure 5-1 are the following: 400 250 100 100 1. Mars Research Program (MRP) 2. Venus Research Program (VRP) 3. Saturn Research Program (SRP) 4. Jupiter Research Program (JRP) Qtr 3 500 250 125 150 1. CAMPUS: a 6-character alphanumeric field to designate each campus of the research center. Qtr 4 600 300 150 150 2. QUARTERLY TARGETS: four numbers indicating the quarterly targets (in thousands of dollars) needed for each campus. This is a 10-digit numeric field including two decimal places. An additional outcome from the interviews discussed above was the identification of categories of programs that needed funds. The following categories were identified: Page 2 of 11 Committee members were assigned specific programs and specific types of donors on the basis of the members' preferences and abilities. Armstrong felt that such an approach would make it possible for the committee members to interact with existing and potential donors in a more professional manner. THE DONORS An examination of existing records identified a set of significant donors (expected annual contributions exceeding $50,000 each). This was done for a number of reasons. First, explicitly identifying such donors would enable the committee to pursue them specifically for contributions. Second, given these donors prior contributions and information from meetings with them, a projection of expected contributions for the current year could be made. This would allow for better planning by the research center for the disbursement of funds to specific programs and campuses. Third, committee members could be more appropriately assigned to pursue specific significant donors.
Expert Answer:
Answer rating: 100% (QA)
Based on the available figures and the text we need to create an SQL query to find the Donor category contributions by program for the third quarter A... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these databases questions
-
Lok Company reports net sales of $5,096,000 for Year 2 and $8,788,000 for Year 3. End-of-year balances for total assets are Year 1, $1,503,000; Year 2, $1,792,000; and Year 3, $1,926,000. (1) Compute...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
A car is initially travelling at 3 0 m / s , which is above the speed limit . The driver sees a speed limit trap ahead and applies the brakes for 5 seconds, causing the car to slow down by 2 m / s...
-
How can a fully dressed person at rest in the middle of a pond on perfectly frictionless ice get to shore?
-
How does the organizational hierarchy of public accounting firms contribute to audit quality?
-
An important omission from flowcharts and matrix techniques is ( ___________________ ). (a) the ability to represent decisions (b) the ability to include internal control considerations (c) the...
-
Lonyear Corporation has collected the following information related to its December 31, 2014, balance sheet. Prepare the assets section of Lonyear Corporations balancesheet. Accounts receivable...
-
did I answer this question correctly? Describe any funding provided for capital expenditure. What is the purpose or value of the item(s) you identified? Some of the funded provide for capital...
-
Prepare Trial Balance? Angela Mosely owns Innovative Designs. The Accounts and their balances for the Trial Balance of the first for January 31, 20X1, the first month of operation, are shown below....
-
1.2 A food manufacturing company orders raw material A, 1200 kg annually. The company estimates its annual storage and handling cost to be RM0.50 per kg per month. The administrative cost for placing...
-
Carla Vista Corporation incurred the following transactions. 1. Purchased raw materials on account $54,710. 2. Raw Materials of $42,480 were requisitioned to the factory. An analysis of the materials...
-
The following probability distributions of return for Stock Y have been estimated: Probability Stock Y 0.3 3% 0.4 4% 0.3 5% Calculate the expected rate of return (), standard deviation (), and the...
-
Direct marketing and mass marketing are becoming a very popular method for communicating with consumers. Giving reasons for their worldwide popularity, show the differences between direct and mass...
-
Blossom Company's current assets at December 31, 2022 are listed below in alphabetical order. Accounts receivable $41,820 Cash 62,220 Finished goods inventory 26,520 Prepaid expenses 3,060 Raw...
-
Willy Ltd was formed on 1 July 2023 to provide courier services. On this date, the company acquired a delivery van from Wagtail Vehicles. The company paid cash of $75 000 to Wagtail Vehicles. The van...
-
Consider a polytropic model for a star, in which so a star with Yp is an "n = = Yp P(r) = Kp(r) = Kp(r)1+1/n = = 4/3 5/3 is an "n 3/2 polytrope", and one with Yp 3 polytrope. (Here n is an index, not...
-
A number of years ago the United Food and Commercial Workers Union organized 800 workers of the 1035 employees at one of the Wilson Brothers food operations in Toronto, Ontario. The employees include...
-
For each of the following situations, indicate whether the taxpayer(s) is (are) required to file a tax return for 2012. Explain your answer. a. Helen is a single taxpayer with interest income in 2012...
-
Russell (age 50) and Linda (age 45) Long have brought you the following information regarding their income and expenses for the current year. Russell owns and operates a landscaping business called...
-
During the 2012 tax year, Irma incurred the following expenses: Union dues..............................................................$275 Tax return preparation...
-
Table 11-2 lists the various activities performed in the expenditure cycle and the journal entries, documents, data, and control issues associated with them. Complete each of the cell entries in this...
-
Match threats in the first column to appropriate control procedures in the second column. Threat 1. Failing to take available purchase discounts 2. Receiving unordered goods 3. Recording and posting...
-
a. Create a spreadsheet to reconcile bank statements. Organize it as follows: i. Ending balance, per bank statement ii. Deposits not included in bank statement (provide space for up to 7) iii. Checks...
Study smarter with the SolutionInn App