Takorfik qasinik piniartorlunilu unneluilersitaq SQLite-mi database tabelimut tunngasunik totali-pisi sineriaata allaffeqatigiiffiat.
Tabeli nuna: immikkuullut
 Pillugu: inuk, pingasuut, kiissaq, nalunaaraat
Tassa allatut namminneqarnerlu aallut: 

```sql
CREATE VIEW total_price_per_person AS 
    SELECT person, SUM(quantity*price) as total_price 
    FROM purchases 
    GROUP BY person;
``` 

Tassa view total_price_per_person iliorfigineqarnera kingorna anguniagaqatigiinni siunertaq pillugu personi imaluunniit, quantitytullu price siullermeerni, purchases tabeliit kingornat pillugit, siullermeerni GROUP BY pillugu personi siullermeerni. Imaluunniit total_price_per_person siullermeqanngitsumik, tamaat illit siullermeqanngitsumik:

```sql
SELECT * FROM total_price_per_person;
```