<prompt> Ho fanoe ka litafole tse peli, kopanya litafole me u hlahise pono.Lethathamo la A: Lebitso la moithuti Lilemo Kereiti --- Johanne 20 A Lethathamo la B: Lebitso la lintlha Test_1 Test_2 --- Johanne 50 80  <response>: Instruction in English: Given two tables, combine the tables and generate a view. . Response in English: Based on the input, we can combine the two tables, Table A student, and Table B score using the SQL JOIN clause. The resulting view, Table C, will include information from both tables:Table C: student_scoreName Age Grade Test_1 Test_2---John 20 A 50 80A SQL statement that can be used to generate the above view is:SELECT A.Name, A.Age, A.Grade, B.Test_1, B.Test_2FROM student AINNER JOIN score BON A.Name B.Name . Response in Sesotho: Ho ipapisitsoe le kenyelletso, re ka kopanya litafole tse peli, Lethathamo la A seithuti, le Lethathamo la B lintlha re sebelisa poleloana ea SQL JOIN. Pono e hlahisoang, Lethathamo la C, le tla kenyelletsa lintlha tse tsoang litafoleng ka bobeli: Lethathamo la C: Leina la_la_moithuti Lilemo Kereiti Test_1 Teko_2 --- Johanne 20 A 50 80 Polelo ya SQL e ka sebediswang ho hlahisa pono e ka hodimo ke: KHETHA A.Name, A.Age, A.Grade, B.Test_1, B.Test_2 HO MOithuti A INNER JOIN lintlha B KA A.Name B.Lebitso 