somodiferenc

import pandas as pd
import matplotlib.pyplot as plt

steel = pd.read_csv('Golden_Ticket_Award_Winners_Steel.csv')
wood = pd.read_csv('Golden_Ticket_Award_Winners_Wood.csv')
roller = pd.read_csv('roller_coasters.csv')

print(steel.head())
#print(steel.info())
print(wood.head())

somodiferenc

price_ground_1 = 1.50
price_ground_2 = 3.0
price_ground_3 = 4.0
price_ground_4 = 4.75

price_premium = 125.0

price_drone_1 = 4.50
price_drone_2 = 9.0
price_drone_3 = 12.0

somodiferenc

-- How many entries in the database are from Africa?
SELECT COUNT(*) FROM countries
WHERE continent = 'Africa';

-- What was the total population of Oceania in 2005?
SELECT SUM(population_years.population) 
FROM population_years JOIN countries
ON population_years.country_id = countries.id
WHERE population_years.year = 2005 
AND countries.continent = 'Oceania';