<prompt> Kutoa meza mbili, kuchanganya meza na kuzalisha mtazamo.Jedwali A: jina la mwanafunzi. Umri. Daraja --- John. 20 Tabla B: alama Jina.  <response>: 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 