text: CREATE TABLE if not exists receipt(id INT,medicineName VARCHAR(255),DateSold VARCHAR(255),qtySold INT, seller_id INT);
  
  INSERT INTO receipt VALUES(2,'Zetia','10/18/2003',8);
  INSERT INTO receipt VALUES(2,'Aggrastat','10/8/2009',2);
  INSERT INTO receipt VALUES(1,'Femibion','9/13/2018',6);
  INSERT INTO receipt VALUES(3,'MidNite','12/22/2012',5);
  INSERT INTO receipt VALUES(2,'Ocrevus','7/26/2009',6);
  INSERT INTO receipt VALUES(3,'Benadryl','5/19/2003',3);
  INSERT INTO receipt VALUES(4,'Paracetamol','7/24/2012',2);
  INSERT INTO receipt VALUES(4,'Maxalt','1/6/2014',8);
  INSERT INTO receipt VALUES(2,'Risperdal','6/17/2007',1);
  INSERT INTO receipt VALUES(3,'Aspirin','9/25/2011',5);
  INSERT INTO receipt VALUES(3,'Zovirax','5/6/2005',6);
  INSERT INTO receipt VALUES(3,'Aspirin','7/2/2000',5);
  INSERT INTO receipt VALUES(1,'Ocrevus','12/24/2017',2);
  INSERT INTO receipt VALUES(3,'Panadol','9/7/2013',3);
  INSERT INTO receipt VALUES(2,'MidNite','2/7/2008',2);
  INSERT INTO receipt VALUES(1,'Paracetamol','11/12/2017',8);
  INSERT INTO receipt VALUES(3,'Novolin','6/4/2002',7);
  INSERT INTO receipt VALUES(1,'Nurofen','1/27/2000',1);
  INSERT INTO receipt VALUES(4,'Singulair','12/2/2017',3);
  INSERT INTO receipt VALUES(4,'Herceptin','10/18/2009',9);
  INSERT INTO receipt VALUES(2,'Aspirin','12/3/2008',9);
  INSERT INTO receipt VALUES(3,'Aggrastat','11/27/2008',2);
  INSERT INTO receipt VALUES(2,'Lasix','8/30/2000',2);
  INSERT INTO receipt VALUES(4,'Zetril','1/7/2003',6);
  INSERT INTO receipt VALUES(3,'Femibion','9/25/2013',8);
  INSERT INTO receipt VALUES(3,'Tylenol','2/26/2011',4);
  INSERT INTO receipt VALUES(1,'Zoloft','2/12/2014',6);
  INSERT INTO receipt VALUES(2,'Zoloft','11/19/2012',6);
  INSERT INTO receipt VALUES(1,'Miralax','3/6/2001',8);
  INSERT INTO receipt VALUES(4,'Ocrevus','2/7/2012',6);
  INSERT INTO receipt VALUES(4,'Zetia','1/8/2022',6);
  INSERT INTO receipt VALUES(3,'NyQuill','8/28/2008',4);
  INSERT INTO receipt VALUES(2,'MidNite','5/23/2001',7);
  INSERT INTO receipt VALUES(2,'Prozac','2/28/2016',3);
  INSERT INTO receipt VALUES(3,'Arcoxia','1/4/2003',5);
  INSERT INTO receipt VALUES(4,'Risperdal','6/7/2000',4);
  INSERT INTO receipt VALUES(4,'Femibion','12/21/2009',6);
  INSERT INTO receipt VALUES(3,'NyQuill','12/22/2003',4);
  INSERT INTO receipt VALUES(1,'Miralax','10/6/2019',9);
  INSERT INTO receipt VALUES(2,'Emend','9/10/2002',4);
  INSERT INTO receipt VALUES(2,'Band-Aid','2/19/2003',6);
  INSERT INTO receipt VALUES(4,'Miralax','1/2/2004',8);
  INSERT INTO receipt VALUES(3,'Symbicort','6/12/2004',8);
  INSERT INTO receipt VALUES(2,'Vioxx','3/29/2015',4);
  INSERT INTO receipt VALUES(2,'Unisom','9/6/2009',3);
  INSERT INTO receipt VALUES(2,'MidNite','6/10/2016',3);
  INSERT INTO receipt VALUES(4,'Nurofen','6/20/2001',8);
  INSERT INTO receipt VALUES(2,'Vaqta','6/8/2005',2);
  INSERT INTO receipt VALUES(4,'Prozac','1/1/2009',4);
  INSERT INTO receipt VALUES(4,'Visine','8/9/2015',2);
  INSERT INTO receipt VALUES(4,'Prozac','12/5/2010',4);
  INSERT INTO receipt VALUES(2,'Singulair','3/7/2009',1);
  INSERT INTO receipt VALUES(2,'Advil','12/16/2018',5);
  INSERT INTO receipt VALUES(3,'Unisom','12/3/2009',1);
  INSERT INTO receipt VALUES(4,'Lasix','5/21/2018',4);
  INSERT INTO receipt VALUES(2,'Visine','1/13/2004',5);
  INSERT INTO receipt VALUES(4,'Zetril','11/4/2014',5);
  INSERT INTO receipt VALUES(3,'Cosopt','10/19/2010',4);
  INSERT INTO receipt VALUES(1,'Band-Aid','9/30/2016',5);
  INSERT INTO receipt VALUES(2,'Risperdal','12/3/2014',9);
  INSERT INTO receipt VALUES(2,'Femibion','5/26/2009',7);
  INSERT INTO receipt VALUES(2,'Maxalt','12/2/2006',4);
  INSERT INTO receipt VALUES(3,'Ibalgin','7/7/2009',4);
  INSERT INTO receipt VALUES(3,'OxyContin','3/20/2020',6);
  INSERT INTO receipt VALUES(2,'Zetril','2/16/2013',2);
  INSERT INTO receipt VALUES(1,'Varivax','10/15/2003',8);
  INSERT INTO receipt VALUES(2,'Prozac','6/16/2012',7);
  INSERT INTO receipt VALUES(1,'Emend','10/20/2017',7);
  INSERT INTO receipt VALUES(1,'Aggrastat','10/26/2004',9);
  INSERT INTO receipt VALUES(4,'Nurofen','8/5/2006',4);
  INSERT INTO receipt VALUES(2,'Emend','5/8/2000',4);
  INSERT INTO receipt VALUES(4,'Ibalgin','5/30/2009',2);
  INSERT INTO receipt VALUES(4,'Ocrevus','5/1/2017',9);
  INSERT INTO receipt VALUES(3,'Symbicort','10/19/2003',5);
  INSERT INTO receipt VALUES(3,'Miralax','12/17/2019',9);
  INSERT INTO receipt VALUES(4,'Ocrevus','6/13/2012',3);
  INSERT INTO receipt VALUES(1,'Ocrevus','6/16/2004',1);
  INSERT INTO receipt VALUES(4,'Aggrastat','12/1/2004',7);
  INSERT INTO receipt VALUES(2,'Cosopt','12/1/2015',3);
  INSERT INTO receipt VALUES(1,'Zetia','12/23/2016',7);
  INSERT INTO receipt VALUES(1,'Lisinopril','5/3/2014',4);
  INSERT INTO receipt VALUES(1,'Fosamax','10/1/2015',8);
  INSERT INTO receipt VALUES(4,'Femibion','3/7/2000',7);
  INSERT INTO receipt VALUES(4,'Cosopt','3/29/2003',1);
  INSERT INTO receipt VALUES(2,'OxyContin','2/28/2014',9);
  INSERT INTO receipt VALUES(2,'Claritin','3/4/2021',2);
  INSERT INTO receipt VALUES(4,'Aspirin','10/12/2000',4);
  INSERT INTO receipt VALUES(4,'Visine','2/28/2011',1);
  INSERT INTO receipt VALUES(2,'Aggrastat','11/10/2013',9);
  INSERT INTO receipt VALUES(3,'Varivax','11/10/2001',5);
  INSERT INTO receipt VALUES(1,'Band-Aid','1/31/2021',1);
  INSERT INTO receipt VALUES(4,'Benadryl','11/30/2014',4);
  INSERT INTO receipt VALUES(3,'Vioxx','11/5/2011',9);
  INSERT INTO receipt VALUES(1,'Unisom','4/25/2002',4);
  INSERT INTO receipt VALUES(4,'Symbicort','2/16/2003',7);
  INSERT INTO receipt VALUES(3,'Makena','10/25/2003',5);
  INSERT INTO receipt VALUES(2,'Symbicort','9/24/2019',8);
  INSERT INTO receipt VALUES(4,'Makena','3/12/2020',1);
  INSERT INTO receipt VALUES(3,'Cosopt','1/10/2003',9);
  INSERT INTO receipt VALUES(1,'Zetia','2/25/2012',9);
  
  