Add square footage data

From the Outlets tab, grab the square footage data and add it to the database with fscskey. Find the sum of the square footages for libraries with multiple branches with some semblance of this:

SELECT fscskey, SUM(`sq_foot`) FROM _202x_sqfoot GROUP BY fscskey;

Then create new table with the now unique fscskeys.

Add this square footage data to the main table with a join something like this:

update _2021 a join _2021_sqfoot b on a.fscskey=b.fscskey set a.sqfoot=b.sqfoot

Scroll to Top