Dogood donor team requested data for the following queries

Assignment Help Basic Computer Science
Reference no: EM131522192

DoGood Donor team requested data for the following queries. Write SQL statements to perform the following tasks: 

· List each donor who is from Norfolk, VA. Include first name, last name, pledge date, and pledge amount. 

· List each month in year 2012 and the total amount of pledge payments made in that month. Display the month name, year and the total amount.

· Find out the project, which had the highest number of credit card payments. Display the project id, name, project fund goal and the number of credit card pledge payments. (Hint: Use cc for the credit card pledge payment type.)

· Display the donors who have made more than one pledge. Include the donor ID, first name, last name and number of pledges.

· Display all pledges made before September 01, 2012. Include all column data from the DD_PLEDGE table.

The DoGood Donor application contains a page that allows administrators to change the ID assigned to a donor in the DD_DONOR table. Create a PL/SQL block to handle this task. Include exception-handling code to address an error raised by attempting to enter a duplicate donor ID. If this error occurs, display the message “This ID is already assigned.” Test the code by changing donor ID 305. (Do not include a COMMIT statement; roll back any DML actions used.)

Reference no: EM131522192

Which elements or attributes are geared toward it leaders

Write and submit a 3- to 5-page paper in which you address the following: For one of your chosen organizations, explain which elements or attributes are geared toward IT leade

Find examples of digital products with a bad

Find examples of digital products with a bad and a good UI. Individual work - Find an example of a good and an example of a bad user interface (UI) from two digital products

What kind of interaction style do both products support

Find an example of a good and an example of a bad user interface (UI) from two digital products, analyzing their interaction styles and using Norman's Interaction Model.

Design a medium sized software system

The aim of this assignment is to test your ability to design a medium sized software system and to demonstrate your ability to manage and present clearly a design document.

Data and layout file structure

This is an array of data, make sure that your output JSON file accurately represents this fact. The data should not just be a bunch of JSON objects in a file with no structu

Major manufacturer of heating equipment

Lennie Edison was employed as a project engineer for Vulcan Systems, which was a major manufacturer of heating equipment. As part of his job, Edison was sometimes required t

Leadership style interview for a company newsletter

Select someone in a leadership position at your organization or at a local company where you might seek employment.  This individual could be a director, manager, supervisor

Create a matrix that explains leadership theories

As a leader, you often need to display or clarify a concept.  A matrix is a grid that contains information and offers a visual model of ideas.  For this assignment, you will

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd