Table: brotherhood_discography
Columns: year
month
single
album
record_label

Question: What's the average year for the good things happening album's single "lady lady lay"?
SQL: SELECT AVG("year") FROM brotherhood_discography WHERE "album" = 'good things happening' AND "single" = '"lady lady lay"'

Question: What album came out before 1975 with the dawn record label and the single "lady lady lay"?
SQL: SELECT "album" FROM brotherhood_discography WHERE "year" < 1975 AND "record_label" = 'dawn' AND "single" = '"lady lady lay"'

Question: What's the earliest year listed for "where are you going to my love" from the album united we stand?
SQL: SELECT MIN("year") FROM brotherhood_discography WHERE "album" = 'united we stand' AND "single" = '"where are you going to my love"'

Question: What month before 1973 is listed for the album united we stand?
SQL: SELECT "month" FROM brotherhood_discography WHERE "year" < 1973 AND "album" = 'united we stand'