user: Question: What's the overall average that has a round less than 7, and a Pick # of 4?
Columns: ['Round', 'Pick #', 'Overall', 'Name', 'Position', 'College']
Types: ['real', 'real', 'real', 'text', 'text', 'text']
Sample row: [1.0, 4.0, 4.0, 'Edgerrin James', 'Running Back', 'Miami (FL)']
SQL:

assistant: SELECT AVG("Overall") FROM "Table" WHERE "Round" < 7.0 AND "Pick #" = 4.0;