Question: Display Transaction Number ( obtained by replacing TR with Transaction in TransactionID ) , CustomerID, and TransactionDate for every transaction that occur in range of

Display Transaction Number (obtained by replacing TR with Transaction in TransactionID), CustomerID, and TransactionDate for every transaction that occur in range of 1 year before January 31st,2023.
(REPLACE, SUBDATE / DATE_SUB)
the result should be
Transaction Number CustomerID TransactionDate
Transaction 007 CU0151/1/202212:00:00 AM
Transaction 019 CU0051/18/202212:00:00 AM
Transaction 036 CU0071/6/202212:00:00 AM
Display Transaction Number ( obtained by

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!