human
Schema:
buildings (id, name, City, Height, Stories, Status)
Companies (id, name, Headquarters, Industry, Sales_billion, Profits_billion, Assets_billion, Market_Value_billion)
Office_locations (building_id, company_id, move_in_year)
Please answer with SQL.
assistant
Sure, I understand.
human
Show me the heights of each building.
assistant
SELECT id , height FROM buildings;
human
What is the average height?
assistant
SELECT AVG ( height ) FROM buildings;
human
How about the max height?
assistant
SELECT height FROM buildings ORDER BY Height DESC LIMIT 1 ;