Lab02_WriteUp
dataset
Question 1 For this question we will use SQL to extract data out of the indiv_sample_nyc table. The schema for this table is given below.
Question 1a Let’s start by looking at 2016 election contributions made by Donald Trump, who was a NY resident during that year. Write a SQL statement that will return the cmte_id, transaction_amt, and name for every contribution made by any donor with “DONALD” and “TRUMP” in their name.