write the sql command from creating table to executing queries

   

 

Context One example of an NGO working on climate causes with a global reach and a large number of volunteers is Greenpeace. This organization was founded in 1971 and aims to promote environmental protection and prevent climate change by advocating for renewable energy, reducing greenhouse gas emissions, and protecting biodiversity. To support their efforts, Greenpeace collects and stores a large amount of data related to environmental resources, climate impacts, and volunteer activities. Their data requirements include: 1. Environmental data: Greenpeace needs data on various environmental resources like air, water, soil, and wildlife to monitor changes in the environment over time. This data includes information on the levels of pollutants in the environment, deforestation rates, and changes in biodiversity. 2. Climate data: Greenpeace also collects data on weather patterns, temperature changes, and sea-level rise. This data helps them understand the impact of climate change on the environment and supports their advocacy efforts to reduce greenhouse gas emissions. 3. Volunteer data: Greenpeace relies heavily on volunteers to support their advocacy campaigns, and thus they need data on volunteer activities, such as the number of volunteers, their demographics, and the activities they participate in. 4. Campaign data: Greenpeace conducts several campaigns to raise awareness about environmental issues and the need for action. They collect data on the impact of these campaigns, such as the number of people reached, the media coverage generated, and the response from policymakers.