Question: Given the following schema: desc teachers; | Field | Type | id | int |name varchar | school_id | int | age | int

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.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
