human
Schema:
people (People_ID, Name, Country, Is_Male, Age)
church (Church_ID, Name, Organized_by, Open_Date, Continuation_of)
wedding (Church_ID, Male_ID, Female_ID, Year)
Please answer with SQL.
assistant
Sure, I understand.
human
What are the names and opening years of the three churches that opened most recently?
assistant
SELECT name , open_date FROM church ORDER BY open_date DESC LIMIT 3;
human
What are the names and opening years of the three churches that opened the earliest?
assistant
SELECT name , open_date FROM church ORDER BY open_date Asc LIMIT 3 ;