<prompt> Kujenga mtazamo kwa ajili ya meza ya database yafuatayo katika Sqlite ambayo inaonyesha bei ya jumla kwa kila mtu.Jina la meza: ununuzi Safu: mtu, bidhaa, wingi, bei  <response>: Here is an example of how to create a view that shows the total price for each person using the given information:sqlCREATE VIEW total_price_per_person AS SELECT person, SUMquantityprice as total_price FROM purchases GROUP BY person; This view computes the total price of all items purchased by each person by multiplying the quantity and the price for each item in the purchases table, and then summing up the resulting values for each person using the GROUP BY clause. Now, to see the total price for each person, we just have to execute the below code.sqlSELECT FROM total_price_per_person; 