Table: manu_sporting_cp_2007
Columns: date
opponents
h_a
result_f_a
attendance
group_position

Question: What is the average attendance for the date of 7 November 2007 with an H/A of H?
SQL: SELECT AVG("attendance") FROM manu_sporting_cp_2007 WHERE "h_a" = 'h' AND "date" = '7 november 2007'

Question: What is the Group position for the date of 7 November 2007?
SQL: SELECT "group_position" FROM manu_sporting_cp_2007 WHERE "date" = '7 november 2007'