CREATE TABLE SATIS
(
  KAYITNO INT PRIMARY KEY,
  SISTEM_NO INT CHECK(SISTEM_NO>500),
  ADI CHAR(40) NULL DEFAULT NULL,
  SOYADI CHAR(40) NULL DEFAULT NULL,
  MEDENI_DURUM CHAR(1) NULL DEFAULT NULL,
  URUN_ADI CHAR(50) NOT NULL DEFAULT NULL,
  BIRIM_FIYAT MONEY,
  ADET INT CHECK(ADET>1),
  SATIS_TARIHI DATE DEFAULT '0000-00-00',
  ODEME_TARIHI DATE DEFAULT'0000-00-00',
  )

  INSERT INTO SATIS (KAYITNO, SISTEM_NO, ADI, SOYADI, MEDENI_DURUM, URUN_ADI, BIRIM_FIYAT, ADET, SATIS_TARIHI, ODEME_TARIHI)
VALUES(100,501,'SELAM','KAÇMAZ','E','TELEVİZYON','2500','5','2018-05-24','2019-01-21'),
(200,503,'HASAN','ALKAN','E','BUZDOLABI','6000','4','2016-02-13','2016-04-28'),
(300,504,'AYŞE','ERMAN','B','ÇAMAŞIR MAKİNASI','1500','10','2014-03-18','2015-02-10'),
(400,505,'FATMA','GÜÇLÜ','E','FIRIN','2000','5','2015-01-10','2015-10-11'),
(500,511,'BURCU','YORGANLI','E','TELEVİZYON','4000','12','2017-11-20','2018-02-15'),
(600,516,'HAKAN','TUNALI','B','TELEVİZYON','3500','8','2018-04-15','2018-08-17'),
(700,519,'YILDIRAY','BAŞTAY','E','KOLTUK TAKIMI','9000','10','2019-03-25','2010-06-20'),
(800,520,'ORHAN','ELMAS','B','FIRIN','3000','20','2008-01-10','2008-10-18')