This is a table .
Question: Give me customer id,subscription and hours they are subscribed for the month of OCT only.For customers that dont have stop date use last date of oct to calculate hours.

Could you provide the solution for the above.