use national join plzQI/ Consider the education database with student and schooltables, where the primary keys are underlined. Give anexpression in SQL for each of the following queries.Student(studentlID. full_name, sat_score, age, school_name)School(school name, street, city, country)1- find the street and the city of all schools in England.2- Find the school street, city, country, and the name ofstudents who their school in 'West Carter' street.3- Display the age and id of student that study in spanish.schools

We have created student and school tables, where the primary keys are underlined. Using below Given…

use national join plz Consider the education database with student and scho ,where the primary keys are underlined. Give an ssion in SQL for each of the following queries. nt(studentID, full_name, sat score, age, school_name ol(school name, street, city, country) find the street and the city of all schools in England. Find the school street, city, country, and the name of students who their school in 'West Carter' street. Display the age and id of student that study in spanish schools