[sql] COFFEE_SALES

Viewer

copydownloadembedprintName: COFFEE_SALES
  1. DROP TABLE COFFEE_SALES;
  2. -- Создаем таблицу.
  3. CREATE TABLE 
  4. COFFEE_SALES (
  5. SALE_DTTM TIMESTAMP NOT NULL,
  6. CARD_NUMBER INT NOT NULL,
  7. COFFEE_TYPE nvarchar(30) NOT NULL,
  8. PRICE INT NOT NULL,
  9. DISCOUNT INT NOT NULL,
  10. GROCERY_FLG INT NOT NULL
  11. );
  12.  
  13. USE [Test]
  14. GO
  15.  
  16. INSERT INTO [COFFEE_SALES]
  17.            ([SALE_DTTM]
  18.            ,[CARD_NUMBER]
  19.            ,[COFFEE_TYPE]
  20.            ,[PRICE]
  21.            ,[DISCOUNT]
  22.                    ,[GROCERY_FLG])
  23.      VALUES
  24. ('10.01.2020 10:52',1,'a',75,5,1),
  25. ('10.01.2020 13:33',1,'b',40,5,0),
  26. ('10.01.2020 13:45',2,'a',75,3,1),
  27. ('12.01.2020 18:01',1,'c',95,3,1),
  28. ('11.01.2020 11:52',1,'a',75,5,1),
  29. ('13.01.2020 12:08',3,'b',65,4,1),
  30. ('16.01.2020 13:45',2,'a',75,3,1),
  31. ('14.01.2020 18:01',1,'c',95,3,1),
  32. ('14.01.2020 10:52',3,'a',75,5,1),
  33. ('16.01.2020 13:33',1,'b',40,5,0),
  34. ('17.01.2020 13:33',2,'a',75,3,1),
  35. ('17.01.2020 18:01',1,'c',95,3,1),
  36. ('11.02.2020 10:52',1,'a',75,5,1),
  37. ('12.02.2020 13:33',1,'b',40,5,0),
  38. ('13.02.2020 13:45',2,'a',75,3,1),
  39. ('15.02.2020 18:01',1,'c',95,3,1),
  40. ('14.02.2020 11:52',1,'a',75,5,1),
  41. ('22.02.2020 12:08',3,'b',65,4,1),
  42. ('23.02.2020 13:45',2,'a',75,3,1),
  43. ('24.02.2020 18:01',1,'c',95,3,1),
  44. ('24.02.2020 10:52',3,'a',75,5,1),
  45. ('25.02.2020 13:33',1,'b',40,5,0),
  46. ('26.02.2020 13:33',2,'a',75,3,1),
  47. ('27.02.2020 18:01',1,'c',95,3,1),
  48. ('26.02.2020 15:05',2,'b',40,3,0),
  49. ('27.02.2020 15:36',2,'b',65,4,1)
  50.  

Editor

You can edit this paste and save as new:


File Description
  • COFFEE_SALES
  • Paste Code
  • 27 Feb-2021
  • 1.37 Kb
You can Share it: