Write SQL to compute campaign net revenue

You are given four relational tables: donors(donor_id INT PRIMARY KEY, segment CHAR(1)) campaigns(campaign_id INT PRIMARY KEY, name VARCHAR(100), channel VARCHAR(20), fixed_cost DECIMAL(12,2), variable_cost_per_reach DECIMAL(12,2)) contacts(contact_id INT PRIMARY KEY, donor_id INT, campaign_id INT, reached_dt DATE) donations(donation_id INT PRIMARY KEY, donor_id INT, campaign_id INT, amount DECIMAL(12,2), donation_dt DATE) Write SQL to answer the three linked questions…