user: ### NOW ANSWER:
Question: What is Apogee, when Designation is Prognoz 6?
Columns: ['Designation', 'Launch date/time ( GMT )', 'Mass', 'Apogee', 'Inclination']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['Prognoz 1', '14 April 1972, 00:54', 'kilograms (lb)', 'kilometres (mi)', '65°']
SQL:

assistant: SELECT "Apogee" FROM "Table" WHERE "Designation" = 'Prognoz 6';