Given the following schema: desc teachers; | Field | Type | id | int |name varchar...

Transcribed Image Text:

Given the following schema: desc teachers; | Field | Type | id | int |name varchar | school_id | int | age | int desc schools; | Field | Type | id | int | name | varchar Please write SQL queries to answer the following: 1. Output a list of all teacher names and the name of the school they teach. 2. Output the school name and average age of teachers at each school. 3. Output the name and age of the oldest teacher(s) at each school. 4. Challenge: Output the difference in age between each teacher and the next oldest teacher at each school. Given the following schema: desc teachers; | Field | Type | id | int |name varchar | school_id | int | age | int desc schools; | Field | Type | id | int | name | varchar Please write SQL queries to answer the following: 1. Output a list of all teacher names and the name of the school they teach. 2. Output the school name and average age of teachers at each school. 3. Output the name and age of the oldest teacher(s) at each school. 4. Challenge: Output the difference in age between each teacher and the next oldest teacher at each school.