Chat History
Plain Language to SQL Query
How to query all employees who manages less than 5 subordinates?
Find students in courses whose teacher has given an average grade above 80.
Query all books that hasn't been restocked in the last 30 days by a manager.
Query all pilots whose airlines have had fewer than 10 flights per day on average over the last 123 days.
Describe your database schema
Please provide your database schema. You can describe it in plain language or use SQL CREATE TABLE statements.