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.

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