After six years and a string of awards, hit television show Sex and the City comes to an end in the USA today.