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 is the Open Date of Pure Church of Christ? | Did you mean the open date of the church named Pure Church of Christ? | yes
assistant
SELECT open_date FROM church WHERE name = 'Pure Church of Christ';
human
who organized the Pure Church of Christ?
assistant
SELECT organized_by FROM church WHERE name = 'Pure Church of Christ';
human
what is the ID of the Church of Christ?
assistant
SELECT church_id FROM church WHERE name = 'Pure Church of Christ';
human
which church was organized by Ezra Booth? | Did you want the name of the church organized by Ezra Booth. | yes
assistant
SELECT name FROM church WHERE organized_by = 'Ezra Booth';
human
Show the opening year in which at least two churches opened
assistant
SELECT open_date FROM church GROUP BY open_date HAVING COUNT( * ) > = 2 ;