Andrew Shue, Thomas Calabro and Heather Locklear starred in which 1990s Fox drama?

Andrew Marton directed the famous chariot race in which 1959 film? In which 1989 comedy and its sequel do Andrew McCarthy and Jonathan Silverman haul around their dead boss? Andrew Melville, who died in 1622, succeeded which man as the leader of Scottish Presbyterianism? Andrew S. Hallidie invented which form of transport and helped install it in San Francisco in 1873? Andy Griffith and Don Knotts opened on Broadway on October 20, 1955, in which play? Andy Griffith starred as a drifter turned TV star in which 1957 drama written by Budd Schulberg? Andy Williams and Henry Mancini both had hits in 1963 with the theme from which film? Andy Williams had a 1972 hit with "Speak Softly Love", the theme from which film?