Calculate Footfalls of given area

Write a PostgreSQL code to count the unique footfalls inside each mall basis it's date. I'll provide the malls' bounding boxes in a shape file. And will also provide the list of footfalls. You need to count the unique footfalls for each date in a mall. The output should be as mentioned in the output file below. Moreover, we even need the intermediate file as shown below.