I'm using Oracle 11. I have thousands of records so this is just a quick example:
Table
Nbr Mon Tues Wed Thurs Fri Sat Sun Start_Date End_Date
1 Y N Y N Y N Y 12/2/2019 12/14/2019 (Mon, Wed, Fri and Sun have 'Y')
2 N N Y Y N N N 12/4/2019 12/5/2019 (Wed and Thurs have 'Y')
Result needed:
Nbr Nbr_of_days
1 7
2 2
Help is very appreciated! Thank you!
Table
Nbr Mon Tues Wed Thurs Fri Sat Sun Start_Date End_Date
1 Y N Y N Y N Y 12/2/2019 12/14/2019 (Mon, Wed, Fri and Sun have 'Y')
2 N N Y Y N N N 12/4/2019 12/5/2019 (Wed and Thurs have 'Y')
Result needed:
Nbr Nbr_of_days
1 7
2 2
Help is very appreciated! Thank you!