В работе

Deforestation project

Introduction

You’re a data analyst for ForestQuery, a non-profit organization. on a mission to reduce deforestation around the world and which raises awareness about this important environmental topic.

Your executive director and her leadership team members are looking to understand which countries and regions around the world seem to have forests that have been shrinking in size, and also which countries and regions have the most significant forest area, both in terms of amount and per cent of total area. The hope is that these findings can help inform initiatives, communications, and personnel allocation to achieve the largest impact with the precious few resources that the organization has at its disposal.

You’ve been able to find tables of data online dealing with forestation as well as total land area and region groupings, and you’ve brought these tables together into a database that you’d like to query to answer some of the most important questions in preparation for a meeting with the ForestQuery executive team coming up in a few days. Ahead of the meeting, you’d like to prepare and disseminate a report for the leadership team that uses complete sentences to help them understand the global deforestation overview between 1990 and 2016.

Steps to Complete

Create a View called “forestation” by joining all three tables - forest_area, land_area and regions in the workspace.

The forest_area and land_area tables join on both country_code AND year.

The regions table joins these based on the only country_code.

In the ‘forestation’ View, include the following:

All of the columns of the origin tables

A new column that provides the per cent of the land area that is designated as forest.

Keep in mind that the column forest_area_sqkm in the forest_area table and the land_area_sqmi in the land_area table are in different units (square kilometres and square miles, respectively), so an adjustment will need to be made in the calculation you write (1 sq mi = 2.59 sq km).

Instructions

You will be creating a report using complete sentences for the executive team. You can use the provided template and work through each section. There are 5 parts to the report you will be working on completing.

Global Situation

Regional Outlook

Country-Level Detail

Recommendations

Appendix: SQL queries used

You will be submitting a PDF version of your report for review.

Навыки: Управление базами данных, Разработка баз данных, SQL, Database Design, MySQL

Показать больше: design a logo for a new project project name is siriusdrive, how to hire programmers for a new project, need a cheap photographer for a wedding max 2 hour service wiulndt mind a new starter, causes of deforestation pdf, 10 causes of deforestation, causes of deforestation, deforestation statistics, deforestation definition, effects of deforestation, deforestation solutions, deforestation facts, project design and describe a new product or service, how to get a project in freelancer as a new, i just want to write about my first day at a new school introduction, lincoln freelance services provides freelance employees for business in baltimore and surrounding communities a new industrial p, a new project for kjgroup, chemtrails exposed a new manhattan project, starting a new testing project, project for a new american century 9/11, project for a new american century pearl harbor quote

О работодателе:
( 2 отзыв(-а, -ов) ) Dammam, Saudi Arabia

ID проекта: #27899823

Поручен:

wanqing525

****Database and database converting program developer**** Hi, there. i can start just now and build your forest database I am a creative and professional Database and database convert application developer having more Больше

$120 USD за 2 дней(-я)
(8 отзывов(-а))
3.7

3 фрилансеров(-а) готовы выполнить эту работу в среднем за $137

iridescent2x15

Hi I have done many programming and technical projects. Kindly contact to share more details about your project in chat. Thank you

$40 USD за 7 дней(-я)
(3 отзывов(-а))
4.5
SqlDevelopment

I can efficiently develop required reports for each of researching parts. I am Senior SQL/BI Developer with 10+ years of exceptional experience and having strong expertise in professional development of complex queries Больше

$250 USD за 2 дней(-я)
(21 отзывов(-а))
4.1