Consider the following relations (tables): Donor(donorld, firstName, lastName, streetAddress, city, state, zipcode) Donates(donorld, charityId, amount, dateDonated)...

Transcribed Image Text:

Consider the following relations (tables): Donor(donorld, firstName, lastName, streetAddress, city, state, zipcode) Donates(donorld, charityId, amount, dateDonated) Charity (charityId, charityName, streetAddress, city, state, zipcode) Create SQL statement for each of the following queries: 1.List zipcode, number of donors in this zipcode for all zipcodes with more than 10 donors. Must create a column name for number of donors in this zipcode for the listing. 2. List donorld, firstName, lastName, streetAddress, city, state, zipcode of all donors who gave over $50 in 2017. 3.List donorld, firstName, lastName, streetAddress, city, state, zipcode of all donors who gave to three or more charities. Consider the following relations (tables): Donor(donorld, firstName, lastName, streetAddress, city, state, zipcode) Donates(donorld, charityId, amount, dateDonated) Charity (charityId, charityName, streetAddress, city, state, zipcode) Create SQL statement for each of the following queries: 1.List zipcode, number of donors in this zipcode for all zipcodes with more than 10 donors. Must create a column name for number of donors in this zipcode for the listing. 2. List donorld, firstName, lastName, streetAddress, city, state, zipcode of all donors who gave over $50 in 2017. 3.List donorld, firstName, lastName, streetAddress, city, state, zipcode of all donors who gave to three or more charities.

Answer rating: 100% (QA)

1 SQL statement to list the zipcode and the number of donors in each zipcode with m... View the full answer