<prompt> Theha pono bakeng sa tafole e latelang ea database ho Sqlite e bontsang kakaretso ea theko ea motho ka mong.Lebitso la tafole: ho reka Likholomo: motho, ntho, bongata, theko  <response>: Instruction in English: Create a view for the following database table in Sqlite which shows the total price for each person. . Response in English: 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; . Response in Sesotho: Mohlala ke ona oa mokhoa oa ho hlahisa pono e bontšang kakaretso ea theko ea motho ka mong ea sebelisang lintlha tse fanoeng: sql BAKA VIEW kakaretso_theko_ka_motho JOALOKAHA HO KHETHA MOTHO, SUMquantityprice e le kakaretso_theko HO TSOA ho reka GROUP BY motho; Pono ena e bala kakaretso ea theko ea lintho tsohle tse rekiloeng ke motho e mong le e mong ka ho atisa bongata le theko ea ntho ka ngoe tafoleng ea theko, ebe o akaretsa boleng ba sephetho sa motho ka mong ea sebelisang poleloana ea GROUP BY. Joale, ho bona kakaretso ea theko ea motho ka mong, re tlameha feela ho etsa khoutu e ka tlase. sql KHETHA HO TLOHA kakaretso_theko_ka_motho; 