Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started