Table: singer_chart_history
Columns: year
single
chart
position
appeared_on_album

Question: When the position is less than 7, what is the appeared on album?
SQL: SELECT "appeared_on_album" FROM singer_chart_history WHERE "position" < 7

Question: After 1996, what is the average position?
SQL: SELECT AVG("position") FROM singer_chart_history WHERE "year" > 1996