added accompanying sql