text: CREATE TABLE elimination (team VARCHAR) -- What is the number of distinct teams that suffer elimination? SELECT COUNT(DISTINCT team) FROM elimination CREATE TABLE elimination (TIME VARCHAR, Eliminated_By VARCHAR) -- Show the times of elimination by "Punk" or "Orton". SELECT TIME FROM elimination WHERE Eliminated_By = "Punk" OR Eliminated_By = "Orton" CREATE TABLE school (Id VARCHAR) -- How many schools are there? SELECT COUNT(*) FROM school CREATE TABLE school (school_name VARCHAR) -- Show all school names in alphabetical order. SELECT school_name FROM school ORDER BY school_name CREATE TABLE school (school_name VARCHAR, LOCATION VARCHAR, mascot VARCHAR) -- List the name, location, mascot for all schools. SELECT school_name, LOCATION, mascot FROM school CREATE TABLE school (enrollment INTEGER) -- What are the total and average enrollment of all schools? SELECT SUM(enrollment), AVG(enrollment) FROM school CREATE TABLE school (mascot VARCHAR, enrollment INTEGER) -- What are the mascots for schools with enrollments above the average? SELECT mascot FROM school WHERE enrollment > (SELECT AVG(enrollment) FROM school) CREATE TABLE school (school_name VARCHAR, enrollment VARCHAR) -- List the name of the school with the smallest enrollment. SELECT school_name FROM school ORDER BY enrollment LIMIT 1 CREATE TABLE school (enrollment INTEGER) -- Show the average, maximum, minimum enrollment of all schools. SELECT AVG(enrollment), MAX(enrollment), MIN(enrollment) FROM school