Create a view for the following database table in Sqlite which shows the total price for each person.
Input: Table name: purchases
Columns: person, item, quantity, price
select person, sum(price) as total_price 
from purchases 
group by person;
SELECT person, SUM(price) 
FROM purchases 
GROUP BY person;