Question $1$: cell E$4-$ Enter a formula that results in the number of room nights available in June

Question $2$: cell K$4-$ Enter a formula that results in the number of occupied room nights in June

Question $3$: cell L$4-$ Enter a formula that results in the occupancy percentage

The next questions are in relation to a pivot table. Please tell me how to filter it properly to get the answers. The filters are $($property$,$ Region, number of rooms, available room night, one, two, three, four, five, occupied room night, percentage$)$

Question $1$: How many properties have an occupancy rate of $90\%$ or more in the cornwall, grasmere, and worcester regions combined?

Question $2$: What is the greatest number of one night stays for any property in the ombersley region with fewer than $800$ available rooms?

Question $3$: What percentage of the gas in the Beesands and upper swell regions stayed more than one night?

Question $4$: What is the difference between the average occupancy rate in the Campden region verse in the kingham region?