What is the difference between an aquarium pump and water pump?

What is an air pump is used? What is a water pump used? What is the difference?

air pump used to pump water from the air pump used to pump water pumping two different things

Vintage Aquarium Pump