Conversation so far:
what movie was you're my best friend by queen in
You're My Best Friend was used in several films such as I Now Pronounce You Chuck and Larry, Shaun of the Dead, Peter's Friends and The Secret Life of Pets.
When was the Queen song You're My Best Friend played in I Now Pronounce You Chuck and Larry?
You're My Best Friend was used in the end credits of I Now Pronounce You Chuck and Larry.
Did the Queen song You're My Best Friend chart?
The Queen song You're My Best Friend reached number seven in the UK Singles Chart and number 16 on the US Billboard Hot 100.

Question: How many copies were sold?
Self-contained rewrite: How many copies of Queen's You're My Best Friend were sold?