一道数据库查询题,请大神解答

Killam Apartment REIT leases high-quality properties in core markets across Canada, typically our leasing agents price our apartments competitively in their markets though occasionally promotions are offered to secure a new lease. Killam is seeking a query that would show the Net Effective Rent (NER)for all future tenants. This query should be structured to allow further analysis by Province, City, Property, Unit Type and NER / ft². Please submit your proposed SQL Query based on the Schema below. 表结构无法发图,可以站内私信我,有偿代答,谢谢

表结构无法发图的原因是什么?

为什么无法发图?

 Please submit your proposed SQL Query based on the Schema below