Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

COMPANY COMPANY_ID (PK) COMPANY_NAME COMPANY_COUNTRY DETAIL INVESTOR FUNDING COMPANY_ID INVESTOR_ID FUNDING_ROUND FUNDED_AT (PK, FK1) (PK, FK2) (PK, FK3) (PK) (PK) FUNDING_ROUND FUNDING_ROUND_TYPE FUNDING_ROUND_CODE RAISED_AMOUNT INVESTOR_ID

image text in transcribed

COMPANY COMPANY_ID (PK) COMPANY_NAME COMPANY_COUNTRY DETAIL INVESTOR FUNDING COMPANY_ID INVESTOR_ID FUNDING_ROUND FUNDED_AT (PK, FK1) (PK, FK2) (PK, FK3) (PK) (PK) FUNDING_ROUND FUNDING_ROUND_TYPE FUNDING_ROUND_CODE RAISED_AMOUNT INVESTOR_ID INVESTOR_NAME INVESTOR_COUNTRY Based on above diagram I want to make an analysis and see to what extent the investor and company geography similarity plays role for investment decisions. 1- List the countries based on company locations and list average funding received per country. a. 2- List the investors who invested in companies which are located in different countries than the investor's own country. 3- List the total amount raised in the seed funding round of companies from Finland. SELECT FUNDING_ROUND a. COMPANY COMPANY_ID (PK) COMPANY_NAME COMPANY_COUNTRY DETAIL INVESTOR FUNDING COMPANY_ID INVESTOR_ID FUNDING_ROUND FUNDED_AT (PK, FK1) (PK, FK2) (PK, FK3) (PK) (PK) FUNDING_ROUND FUNDING_ROUND_TYPE FUNDING_ROUND_CODE RAISED_AMOUNT INVESTOR_ID INVESTOR_NAME INVESTOR_COUNTRY Based on above diagram I want to make an analysis and see to what extent the investor and company geography similarity plays role for investment decisions. 1- List the countries based on company locations and list average funding received per country. a. 2- List the investors who invested in companies which are located in different countries than the investor's own country. 3- List the total amount raised in the seed funding round of companies from Finland. SELECT FUNDING_ROUND a

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Analysis For Financial Management

Authors: Robert C Higgins

8th International Edition

0071257063, 9780071257060

More Books

Students also viewed these Finance questions