LeetCode SQL Medium

Currently Playing: Leetcode MEDIUM 3050 - Pizza Toppings Cost Analysis- Solved by Everyday Data Science | JOIN v CONCAT

Question: https://leetcode.com/problems/pizza-toppings-cost-analysis/description/ SQL Schema: Create table if not exists Toppings(topping_name varchar(100), cost decimal(5,2)) Truncate table Toppings insert into Toppings (topping_name, cost) values ('Pepperoni', '0.5') insert into Toppings (topping_name, cost) values ('Sausage', '0.7') insert into Toppings (topping_name, cost) values ('Chicken', '0.55') insert into Toppings (topping_name, cost) values ('Extra Cheese', '0.4') Pandas Schema: data = [['Pepperoni', 0.5], ['Sausage', 0.7], ['Chicken', 0.55], ['Extra Cheese', 0.4]] toppings = pd.DataFrame(data, columns=['topping_name', 'cost']).astype({'topping_name':'object', 'cost':'Float64'}) #datasciencequestions #leetcodesolutions #dataengineering