Write and run SQL statements to perform the following tasks by using the tables below:

$$ dd$\_$donor

$$ dd$\_$project

$$ dd$\_$status

$$ dd$\_$pledge

$$ dd$\_$payment

a$)$ List each donor who has made a pledge and paid in a single lump sum payment $($i$.$e$.,$ where $$paymonths$$ is equal to $0).$ Include the donor$$s first name, last name, pledge date, and pledge amount.

SELECT

d$.$first$\_$name,

d$.$last$\_$name,

p$.$pledge$\_$date,

p$.$pledge$\_$amount

FROM

dd$\_$donor d

JOIN

dd$\_$pledge p ON d$.$donor$\_$id $=$ p$.$donor$\_$id

JOIN

dd$\_$payment pm ON p$.$pledge$\_$id $=$ pm$.$pledge$\_$id

WHERE

pm$.$paymonths $=0$;

b$)$ Display an unduplicated list of projects $($ID and name$)$ that have received pledges. Include only those projects with assigned pledges.

SELECT DISTINCT

p$.$project$\_$id$,$

p$.$project$\_$name

FROM

dd$\_$project p

JOIN

dd$\_$pledge pl ON p$.$project$\_$id $=$ pl$.$project$\_$id;

c$)$ Show the number of pledges made by each donor. Include the donor ID$,$ first name, last name, and number of pledges.

SELECT

d$.$donor$\_$id$,$

d$.$first$\_$name,

d$.$last$\_$name,

COUNT$($p$.$pledge$\_$id$)$ AS number$\_$of$\_$pledges

FROM

dd$\_$donor d

JOIN

dd$\_$pledge p ON d$.$donor$\_$id $=$ p$.$donor$\_$id

GROUP BY

d$.$donor$\_$id$,$

d$.$first$\_$name,

d$.$last$\_$name;