Given the following schemas:

1. TABLE "public.teamsfranchises"

2. COLUMN | TYPE | Modifiers

3. ------------+------------------------+-----------

4. franchid | CHARACTER varying(255) |

5. franchname | CHARACTER varying(255) |

6. active | CHARACTER varying(255) |

7. naassoc | CHARACTER varying(255) |

__________________________________________________________________________

1. TABLE "public.teams"

2. COLUMN | TYPE | Modifiers

3. ----------------+------------------------+-----------

4. yearid | BIGINT |

5. franchid | CHARACTER varying(255) |

6. w | BIGINT |

7. l | BIGINT |

8. NAME | CHARACTER varying(255) |

9. attendance | CHARACTER varying(255) |

Write an SQL query to query Franchise name and average total yearly franchise attendance from (>=) 1997. The output schema should be in the following form: (franchise name, attendance).