INSERT INTO Transactions_facts_table (CarId, CustomerId, SalesmanId, SalesDate, Price, Amount, Value)
     VALUES (1, 1, 1, '2010-05-29', 30000, 1, 30000);

INSERT INTO Transactions_facts_table (CarId, CustomerId, SalesmanId, SalesDate, Price, Amount, Value)
     VALUES (2, 2, 2, '2010-05-29', 35000, 1, 35000);

INSERT INTO Transactions_facts_table (CarId, CustomerId, SalesmanId, SalesDate, Price, Amount, Value)
     VALUES (3, 3, 2, '2010-05-30', 40000, 1, 40000);

INSERT INTO Transactions_facts_table (CarId, CustomerId, SalesmanId, SalesDate, Price, Amount, Value)
     VALUES (4, 4, 3, '2010-06-04', 50000, 1, 50000);

INSERT INTO Transactions_facts_table (CarId, CustomerId, SalesmanId, SalesDate, Price, Amount, Value)
     VALUES (5, 5, 4, '2010-06-05', 65000, 1, 65000);

INSERT INTO Transactions_facts_table (CarId, CustomerId, SalesmanId, SalesDate, Price, Amount, Value)
     VALUES (6, 6, 5, '2010-06-05', 66000, 1, 66000);

INSERT INTO Transactions_facts_table (CarId, CustomerId, SalesmanId, SalesDate, Price, Amount, Value)
     VALUES (7, 7, 2, '2010-06-12', 70000, 1, 70000);

INSERT INTO Transactions_facts_table (CarId, CustomerId, SalesmanId, SalesDate, Price, Amount, Value)
     VALUES (8, 8, 3, '2010-06-15', 42000, 1, 42000);

INSERT INTO Transactions_facts_table (CarId, CustomerId, SalesmanId, SalesDate, Price, Amount, Value)
     VALUES (9, 9, 3, '2010-06-16', 60000, 1, 60000);

INSERT INTO Transactions_facts_table (CarId, CustomerId, SalesmanId, SalesDate, Price, Amount, Value)
     VALUES (10, 10, 4, '2010-06-18', 40000, 1, 40000);

INSERT INTO Transactions_facts_table (CarId, CustomerId, SalesmanId, SalesDate, Price, Amount, Value)
     VALUES (11, 11, 2, '2010-06-22', 45000, 2, 90000);

INSERT INTO Transactions_facts_table (CarId, CustomerId, SalesmanId, SalesDate, Price, Amount, Value)
     VALUES (12, 12, 5, '2010-06-23', 45000, 1, 45000);

INSERT INTO Transactions_facts_table (CarId, CustomerId, SalesmanId, SalesDate, Price, Amount, Value)
     VALUES (13, 13, 2, '2010-07-03', 50000, 1, 50000);

INSERT INTO Transactions_facts_table (CarId, CustomerId, SalesmanId, SalesDate, Price, Amount, Value)
     VALUES (14, 14, 3, '2010-07-10', 60000, 1, 60000);

INSERT INTO Transactions_facts_table (CarId, CustomerId, SalesmanId, SalesDate, Price, Amount, Value)
     VALUES (55, 61, 5, '2011-09-09', 220000, 1, 220000);

INSERT INTO Transactions_facts_table (CarId, CustomerId, SalesmanId, SalesDate, Price, Amount, Value)
     VALUES (56, 32, 3, '2011-09-15', 260000, 1, 260000);

INSERT INTO Transactions_facts_table (CarId, CustomerId, SalesmanId, SalesDate, Price, Amount, Value)
     VALUES (57, 24, 4, '2011-09-20', 285000, 1, 285000);

INSERT INTO Transactions_facts_table (CarId, CustomerId, SalesmanId, SalesDate, Price, Amount, Value)
     VALUES (58, 17, 2, '2011-09-26', 310000, 1, 310000);

INSERT INTO Transactions_facts_table (CarId, CustomerId, SalesmanId, SalesDate, Price, Amount, Value)
     VALUES (59, 12, 2, '2011-09-30', 52000, 1, 52000);

INSERT INTO Transactions_facts_table (CarId, CustomerId, SalesmanId, SalesDate, Price, Amount, Value)
     VALUES (60, 49, 2, '2011-10-02', 60000, 1, 60000);

INSERT INTO Transactions_facts_table (CarId, CustomerId, SalesmanId, SalesDate, Price, Amount, Value)
     VALUES (61, 31, 4, '2011-10-14', 80000, 1, 80000);

INSERT INTO Transactions_facts_table (CarId, CustomerId, SalesmanId, SalesDate, Price, Amount, Value)
     VALUES (62, 43, 4, '2011-10-17', 190000, 1, 190000);

INSERT INTO Transactions_facts_table (CarId, CustomerId, SalesmanId, SalesDate, Price, Amount, Value)
     VALUES (63, 5, 4, '2011-10-25', 8000, 1, 8000);

INSERT INTO Transactions_facts_table (CarId, CustomerId, SalesmanId, SalesDate, Price, Amount, Value)
     VALUES (64, 41, 3, '2011-11-06', 12000, 1, 12000);

INSERT INTO Transactions_facts_table (CarId, CustomerId, SalesmanId, SalesDate, Price, Amount, Value)
     VALUES (65, 60, 3, '2011-11-12', 19000, 1, 19000);

INSERT INTO Transactions_facts_table (CarId, CustomerId, SalesmanId, SalesDate, Price, Amount, Value)
     VALUES (66, 42, 5, '2011-11-19', 35000, 1, 35000);
Last modified: Friday, 5 February 2021, 11:07 AM