Query Sum by Shift MSSQL

I have 3 table called stop,trip,and shift. I would like to do something so the result can like the image

I'm having hard time for this, please help me i will appreciate it if you guys can help me on this :D

Thanks in advance