title: I do select on sql and create new columns based on what I want to lookup inside of it and add another column with looked up answers
body: <p>I need to make sql command work, thing is next
  I have a table, from where I do make sql select,
  during select I create 2 additional columns (rem_day and prev_day)
  I want to add another column during that selection which will be result
  of lookuped value to find prev_day 'summary' value for each rem_day</p>
  
  <p>I tried joins but failed with it</p>
  
  <p>query:</p>
  
  <pre><code>SELECT unique_id, branch_id, branch_name, type + ' ' + class typeclass, sum(pistol_data) summary, tr_date, date, 
  convert(varchar, branch_id, 0) + type + ' ' + class + ' ' + convert(varchar, tr_date, 101) rem_day, 
  convert(varchar, branch_id, 0) + type + ' ' + class + ' ' + convert(varchar, tr_date - 1, 101) prev_day 
  FROM golden_oil.dbo.transactions WHERE deleted = 0 and description = 1 
  GROUP BY unique_id, branch_id, branch_name, type, class, tr_date, date ORDER BY tr_date DESC, branch_id ASC
  </code></pre>
  
  <p>table:</p>
  
  <pre><code>USE [golden_oil]
  GO
  
  SET ANSI_NULLS ON
  GO
  
  SET QUOTED_IDENTIFIER ON
  GO
  
  CREATE TABLE [dbo].[transactions](
      [unique_id] [int] NULL,
      [branch_id] [int] NULL,
      [branch_name] [nvarchar](max) NULL,
      [username] [varchar](max) NULL,
      [tank_id] [int] NULL,
      [type] [nvarchar](max) NULL,
      [class] [nvarchar](max) NULL,
      [pistol_name] [nvarchar](max) NULL,
      [pistol_data] [float] NULL,
      [adjustment] [numeric](7, 5) NULL,
      [date] [datetime] NULL,
      [deleted] [bit] NULL,
      [description] [nvarchar](max) NULL,
      [multiplier] [int] NULL,
      [tr_date] [datetime] NULL
  ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  GO
  
  </code></pre>
  
  <p>sample data:</p>
  
  <pre><code>INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (1,1,'test','test',1,'Dizeli',NULL,'Dizeli:_1',7331.87,0,'7/24/2019',0,1,-1,'7/22/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (1,1,'test','test',1,'Dizeli',NULL,'Dizeli:_2',134804.57,0,'7/24/2019',0,1,-1,'7/22/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (1,1,'test','test',1,'Dizeli',NULL,'Dizeli:_3',167585.77,0,'7/24/2019',0,1,-1,'7/22/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (1,1,'test','test',1,'Dizeli',NULL,'Dizeli:_4',269361.97,0,'7/24/2019',0,1,-1,'7/22/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (1,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari_2',5154.42,0,'7/24/2019',0,1,-1,'7/22/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (1,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari_1',12762.88,0,'7/24/2019',0,1,-1,'7/22/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (1,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari_4',47979.9,0,'7/24/2019',0,1,-1,'7/22/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (1,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari_8',122833.33,0,'7/24/2019',0,1,-1,'7/22/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (1,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari_5',126579.4,0,'7/24/2019',0,1,-1,'7/22/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (1,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari_3',133036.77,0,'7/24/2019',0,1,-1,'7/22/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (1,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari_7',234392.17,0,'7/24/2019',0,1,-1,'7/22/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (1,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari_6',293191.89,0,'7/24/2019',0,1,-1,'7/22/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (1,1,'test','test',3,'Benzini','Premiumi','Benzini:Premiumi_1',1361.75,0,'7/24/2019',0,1,-1,'7/22/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (1,1,'test','test',3,'Benzini','Premiumi','Benzini:Premiumi_2',27410.16,0,'7/24/2019',0,1,-1,'7/22/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (1,1,'test','test',3,'Benzini','Premiumi','Benzini:Premiumi_4',43258.11,0,'7/24/2019',0,1,-1,'7/22/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (1,1,'test','test',3,'Benzini','Premiumi','Benzini:Premiumi_3',43588.9,0,'7/24/2019',0,1,-1,'7/22/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (2,1,'test','test',1,'Dizeli',NULL,'Dizeli:_1',7712.23,0,'7/24/2019',0,1,-1,'7/23/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (2,1,'test','test',1,'Dizeli',NULL,'Dizeli:_2',135219.57,0,'7/24/2019',0,1,-1,'7/23/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (2,1,'test','test',1,'Dizeli',NULL,'Dizeli:_3',167928.19,0,'7/24/2019',0,1,-1,'7/23/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (2,1,'test','test',1,'Dizeli',NULL,'Dizeli:_4',269674.97,0,'7/24/2019',0,1,-1,'7/23/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (2,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari_2',5355.27,0,'7/24/2019',0,1,-1,'7/23/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (2,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari_1',13361.86,0,'7/24/2019',0,1,-1,'7/23/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (2,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari_4',48301.26,0,'7/24/2019',0,1,-1,'7/23/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (2,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari_8',123368.18,0,'7/24/2019',0,1,-1,'7/23/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (2,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari_5',127209.37,0,'7/24/2019',0,1,-1,'7/23/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (2,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari_3',133207.91,0,'7/24/2019',0,1,-1,'7/23/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (2,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari_7',235021.41,0,'7/24/2019',0,1,-1,'7/23/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (2,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari_6',294159.17,0,'7/24/2019',0,1,-1,'7/23/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (2,1,'test','test',3,'Benzini','Premiumi','Benzini:Premiumi_1',1361.75,0,'7/24/2019',0,1,-1,'7/23/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (2,1,'test','test',3,'Benzini','Premiumi','Benzini:Premiumi_2',27410.16,0,'7/24/2019',0,1,-1,'7/23/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (2,1,'test','test',3,'Benzini','Premiumi','Benzini:Premiumi_4',43258.11,0,'7/24/2019',0,1,-1,'7/23/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (2,1,'test','test',3,'Benzini','Premiumi','Benzini:Premiumi_3',43588.9,0,'7/24/2019',0,1,-1,'7/23/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (7,1,'test','test',1,'Dizeli',NULL,'Dizeli:_1',7759.06,0,'7/25/2019',0,1,-1,'7/24/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (7,1,'test','test',1,'Dizeli',NULL,'Dizeli:_2',135799.31,0,'7/25/2019',0,1,-1,'7/24/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (7,1,'test','test',1,'Dizeli',NULL,'Dizeli:_3',168210.16,0,'7/25/2019',0,1,-1,'7/24/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (7,1,'test','test',1,'Dizeli',NULL,'Dizeli:_4',270682.61,0,'7/25/2019',0,1,-1,'7/24/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (7,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari_2',5730.7,0,'7/25/2019',0,1,-1,'7/24/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (7,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari_1',13676.06,0,'7/25/2019',0,1,-1,'7/24/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (7,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari_4',48732.65,0,'7/25/2019',0,1,-1,'7/24/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (7,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari_8',123741.67,0,'7/25/2019',0,1,-1,'7/24/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (7,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari_5',127708.61,0,'7/25/2019',0,1,-1,'7/24/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (7,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari_3',133428,0,'7/25/2019',0,1,-1,'7/24/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (7,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari_7',235559.97,0,'7/25/2019',0,1,-1,'7/24/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (7,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari_6',294871.09,0,'7/25/2019',0,1,-1,'7/24/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (7,1,'test','test',3,'Benzini','Premiumi','Benzini:Premiumi_1',1361.75,0,'7/25/2019',0,1,-1,'7/24/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (7,1,'test','test',3,'Benzini','Premiumi','Benzini:Premiumi_2',27410.16,0,'7/25/2019',0,1,-1,'7/24/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (7,1,'test','test',3,'Benzini','Premiumi','Benzini:Premiumi_4',43258.11,0,'7/25/2019',0,1,-1,'7/24/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (7,1,'test','test',3,'Benzini','Premiumi','Benzini:Premiumi_3',43588.9,0,'7/25/2019',0,1,-1,'7/24/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (8,1,'test','test',1,'Dizeli',NULL,'Dizeli:_1',7969.62,0,'7/25/2019',0,1,-1,'7/25/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (8,1,'test','test',1,'Dizeli',NULL,'Dizeli:_2',136254.58,0,'7/25/2019',0,1,-1,'7/25/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (8,1,'test','test',1,'Dizeli',NULL,'Dizeli:_3',168373.9,0,'7/25/2019',0,1,-1,'7/25/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (8,1,'test','test',1,'Dizeli',NULL,'Dizeli:_4',271264.41,0,'7/25/2019',0,1,-1,'7/25/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (8,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari_2',6365.51,0,'7/25/2019',0,1,-1,'7/25/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (8,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari_1',13821.18,0,'7/25/2019',0,1,-1,'7/25/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (8,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari_4',48748.4,0,'7/25/2019',0,1,-1,'7/25/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (8,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari_8',123884.81,0,'7/25/2019',0,1,-1,'7/25/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (8,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari_5',127981.33,0,'7/25/2019',0,1,-1,'7/25/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (8,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari_3',133745.19,0,'7/25/2019',0,1,-1,'7/25/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (8,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari_7',236539.28,0,'7/25/2019',0,1,-1,'7/25/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (8,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari_6',295695.87,0,'7/25/2019',0,1,-1,'7/25/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (8,1,'test','test',3,'Benzini','Premiumi','Benzini:Premiumi_1',1361.75,0,'7/25/2019',0,1,-1,'7/25/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (8,1,'test','test',3,'Benzini','Premiumi','Benzini:Premiumi_2',27410.16,0,'7/25/2019',0,1,-1,'7/25/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (8,1,'test','test',3,'Benzini','Premiumi','Benzini:Premiumi_4',43258.11,0,'7/25/2019',0,1,-1,'7/25/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (8,1,'test','test',3,'Benzini','Premiumi','Benzini:Premiumi_3',43588.9,0,'7/25/2019',0,1,-1,'7/25/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (9,1,'test','test',1,'Dizeli',NULL,'Dizeli: Migeba',6000,0,'7/25/2019',0,4,1,'7/25/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (12,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari Sacdeli Chamosxma',20,0,'7/25/2019',0,2,-1,'7/25/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (12,1,'test','test',2,'Benzini','Regulari','Benzini:Regulari Chabruneba',20,0,'7/25/2019',0,3,1,'7/25/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (12,1,'test','test',3,'Benzini','Premiumi','Benzini:Premiumi Sacdeli Chamosxma',30,0,'7/25/2019',0,2,-1,'7/25/2019');
  INSERT INTO dbo.transactions(unique_id,branch_id,branch_name,username,tank_id,type,class,pistol_name,pistol_data,adjustment,date,deleted,description,multiplier,tr_date) VALUES (12,1,'test','test',3,'Benzini','Premiumi','Benzini:Premiumi Chabruneba',30,0,'7/25/2019',0,3,1,'7/25/2019');
  
  </code></pre>