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
Show the information about weddings after year 2014.
assistant
SELECT * FROM wedding WHERE year > 2014;
human
Show the male names in all weddings after 2014.
assistant
SELECT T2.name FROM wedding AS T1 JOIN people AS T2 ON T1.male_id = T2.people_id WHERE T1.year > 2014 ;