Information on pet names and owner names side by side.

SELECT Owners.Name Owner, Pets.Name Pet
from Owners
JOIN Pets
	ON Owners.OwnerID = 
	Pets.OwnerID;
  
  Match up all procedures performed to their descriptions
  
  SELECT PetID, ProceduresHistory.Date, ProceduresHistory.ProcedureType ProcedureType,
		Description, Price
from ProceduresHistory
JOIN ProceduresDetails
	ON ProceduresHistory.ProcedureSubCode = 
	ProceduresDetails.ProcedureSubCode;
  
  Most popular procedures and how much they cost.
  
  SELECT PetID, ProceduresHistory.Date, count(ProceduresHistory.ProcedureType) Most_Occuring,
		Description, Price
from ProceduresHistory
JOIN ProceduresDetails
	ON ProceduresHistory.ProcedureSubCode = 
	ProceduresDetails.ProcedureSubCode
	GROUP BY PetID
	ORDER BY Most_Occuring DESC
	LIMIT 4;