Hello everyone,
I am stuck here you guys can help me out. I have historical rates I need to apply only one rates based on pickup date.
i want to write sql query that will only pick up RatePerKg between effective and expiry date.
in this example pickup date 30-jun-2023 which is under this bucket.
32030 0003001155G20 30-Jun-23 18-Jun-23 30-Dec-23 $10.18