get absence day wise

Summary:

sql query to get absence details day wise, like if i pass specific date and assignment_id then i should be getting 1 ,

if there is a 0.5 applied on that specific day then i should get 0.5 on that specific date and for the assignment_id respectively.

Any help is greatly appreciated.

Content (please ensure you mask any confidential information):

sql query to get absence details day wise, like if i pass specific date and assignment_id then i should be getting 1 ,

if there is a 0.5 applied on that specific day then i should get 0.5 on that specific date and for the assignment_id respectively.