 Create a view for the following database table in Sqlite which shows the total price for each person. Table name: purchasesColumns: person, item, quantity, price
 CREATE VIEW person_total AS SELECT person، SUM(quantity * price) AS total_price FROM purchases GROUP BY person;
 CREATE VIEW person_total AS SELECT person, SUM(quantity * price) AS total_price FROM purchases GROUP BY person;
 أنشئ عرضًا لجدول قاعدة البيانات التالي في Sqlite الذي يظهر السعر الإجمالي لكل شخص. اسم الجدول: purchases الأعمدة: person ، item ، quantity ، price