Table: chicago_discography
Columns: year
title
us_100
us_ac
lead_singer
album
label_and_cat

Question: Which album was on June 1998?
SQL: SELECT "album" FROM chicago_discography WHERE "year" = 'june 1998'

Question: Which album has a label and cat# full moon/warner 28628?
SQL: SELECT "album" FROM chicago_discography WHERE "label_and_cat" = 'full moon/warner 28628'

Question: What is the US 100 rank of Champlin's Chicago 19 album with a US AC of 1?
SQL: SELECT "us_100" FROM chicago_discography WHERE "lead_singer" = 'champlin' AND "album" = 'chicago 19' AND "us_ac" = '1'

Question: What is the US AC of the label and cat# reprise 19466?
SQL: SELECT "us_ac" FROM chicago_discography WHERE "label_and_cat" = 'reprise 19466'