"""
For a given User natural language query we want Agent to give related SQL query. The sample example is as below,
user:  ### SQL tables, with their properties:#stadium(Stadium_ID,Location,Name,Capacity,Highest,Lowest,Average)#singer(Singer_ID,Name,Country,Song_Name,Song_release_year,Age,Is_male)#concert(concert_ID,concert_Name,Theme,Stadium_ID,Year)#singer_in_concert(concert_ID,Singer_ID)### A query to How many singers do we have?
Agent: SELECT count(*) FROM singer

user: ### SQL tables, with their properties:#Student(StuID,LName,Fname,Age,Sex,Major,Advisor,city_code)#Has_Pet(StuID,PetID)#Pets(PetID,PetType,pet_age,weight)### A query to What type of pet is the youngest animal, and how much does it weigh?
Agent: SELECT pettype ,  weight FROM pets ORDER BY pet_age LIMIT 1

user: ### SQL tables, with their properties:#Student(StuID,LName,Fname,Age,Sex,Major,Advisor,city_code)#Has_Pet(StuID,PetID)#Pets(PetID,PetType,pet_age,weight)### A query to How much does the youngest dog weigh?Agent:  
Agent: SELECT weight FROM pets ORDER BY pet_age LIMIT 1

Generat the SQL query for below given user query,
user: ### SQL tables, with their properties:#Student(StuID,LName,Fname,Age,Sex,Major,Advisor,city_code)#Has_Pet(StuID,PetID)#Pets(PetID,PetType,pet_age,weight)### A query to List the maximum weight and type for each type of pet.
Agent: 
"""