How many likes were received on all the posts made by friends on the day before today in a dataset that includes two tables: one containing information about the date, post$\_$id$,$ relationship $($e$.$ g$.,$ friend, group, page$),$ and interaction $($e$.$ g$.,$ like, share, etc. $),$ and another table containing post$\_$id and the ID of the person who posted them?

Assume today as the day you are solving the Problem.

Tables Schema as Below:

post$\_$interactions

columnName dataType

interaction$\_$id INT

post$\_$id INT

interaction$\_$type VARCHAR$(50)$

interaction$\_$date DATE

relationship$\_$type VARCHAR$(50)$

posts

columnName dataType

post$\_$id INT

author$\_$id INT