Table: yardbirds_discography
Columns: date
title
origin
label_cat_no
chart_no

Question: What is the highest chart number for the song Yardbirds aka Roger the Engineer?
SQL: SELECT MAX("chart_no") FROM yardbirds_discography WHERE "title" = 'yardbirds aka roger the engineer'

Question: What is the average chart number for 11/1965?
SQL: SELECT AVG("chart_no") FROM yardbirds_discography WHERE "date" = '11/1965'

Question: What is origin country for a title that charted at 52?
SQL: SELECT "origin" FROM yardbirds_discography WHERE "chart_no" = 52