TSQL Challenge 33
TSQL Challenge 33 - Calculate list of bookings fully paid on the booking date
Here is an interesting problem which deals with the amount of data to be excluded rather than included. This problem is related to a reservation system where customers book a service and pay it in one or more transactions which may happen on different dates.
A report is required to find the bookings that were fully paid at initial booking time. When a booking is made the client can either pay a deposit or fully pay the booking, if the client chooses to not fully pay the booking then it should not be reported upon. A booking is to be deemed to be fully paid if the cost of the booking is balanced by payment receipts on the same day as the booking creation.
Your job is to identify the booking transactions that were fully paid on the booking dates itself.
- TSQL Challenge 33 - Evaluation Queue
- TSQL Challenge 33 - All Submissions
- TSQL Challenge 33 - Accepted Submissions
- TSQL Challenge 33 - Basic Testing Results
- TSQL Challenge 33 - Logic Testing Results
- TSQL Challenge 33 - Performance Testing Comparision
- TSQL Challenge 33 - Winners
Subscribe
