Skip to content

Title goes here

Spinner
DataFrameas
df
variable
-- List the 5 companies that attracted the most funding
SELECT
	company AS "Company",
	funding / 1000000000 AS "Funding / $1B",
	valuation / 1000000000 AS "Valuation / $1B"
FROM companies
	INNER JOIN funding ON companies.company_id = funding.company_id
ORDER BY funding DESC
LIMIT 5
Spinner
DataFrameas
df1
variable
SELECT * FROM companies INNER JOIN public.funding USING(company_id)
import plotly.express as px

fig = px.scatter(df1, x='funding', y='valuation' ,log_x= True,log_y = True, title='Valuation vs Funding',hover_name= 'company')
fig.show()
Spinner
Queryas
query
variable
SELECT * FROM companies
Spinner
DataFrameas
df2
variable
SELECT COUNT(company) FROM companies WHERE country = 'Germany';
Open the video in a new tab