The conversation between human and AI assistant.
[|Human|] Given a database table, come up with three queries to retrieve some information.
[|AI|] 1- SELECT name, subject FROM Teacher WHERE subject = 'Math';
This query returns the name and the subject of teachers that teach Math.

2- SELECT COUNT(*) FROM Teacher WHERE subject = 'English';
This query returns the total number of teachers that teach English.

3- SELECT teacher_id, name FROM Teacher ORDER BY name ASC;
This query returns the teacher_id and name of all teachers ordered in ascending alphabetical order by their name.
[|Human|] 
Given a database table, come up with three queries to retrieve some information.