Write Some SQL Commands

Below are some sample data for the table. Insert into Transaction_Detail Values(1,6,timestamp‘2016-12-01 09:00:00’, timestamp‘2017-11-01 09:00:00’,null,0, 0); Insert into Transaction_Detail Values(2,7,timestamp‘2017-01-02 08:30:00’, null, timestamp‘2017-12-02 09:00:00’,10, 1); Insert into Transaction_Detail Values(3,8,timestamp‘2017-03-05 12:30:00’, timestamp‘2017-03-05 12:30:00’,null,0, 0); Insert into Transaction_Detail Values(4,9,timestamp‘2017-11-07 11:20:00’, null, timestamp‘2017-12-07 09:00:00’,20, 11); Insert into Transaction_Detail Values(5,6,timestamp‘2017-10-10 16:00:00’, null, timestamp‘2017-12-10 09:00:00’,30, 10); Please answer the SQL commands implementing the following questions. Explain your answers. You can verify them in your database. (100 points in total, 20 points each.) Hint: if you want to use timestamp in where clause, you need to use to_timestamp function, e.g., to_timestamp('12-01-2012 21:24:00', 'dd-mm-yyyy hh24:mi:ss') List all the transaction details for the orders with outstanding payments (where customers have not fully completed their payments and still have some amount due). List the customer IDs who have ordered before Nov 6,2017. List the number of customers who have ordered in the store. Customer 2 has completed the transaction earlier than the due date. Assume the transaction was completed on Nov 1, 2017, update the table. List the total amount of payment the store is expecting from all the customers.