The Sara Little Center was located at Tacoma Art Museumâs former location at 1123 Pacific Avenue. Although never fully accessioned into the museumâs permanent collection, the Sara Little Center has been formally deaccessioned in its entirety. It is no longer at Tacoma Art Museum.
A common table expression (CTE) can be thought of as a temporary result set that is defined within the execution scope of a single SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement. A CTE is similar to a derived table in that it is not stored as an object and lasts only for the duration of the query.
Note how weâve defined a common table expression âquota_cteâ, that we use just like any ordinary table or view in the query. The magic happens in the WITH clause, where we define the CTE. Iâve added an integer column to the CTE called QuotaVersion which is basically a counter. Each sales personâs first quota has QuotaVersion=1, the next one has QuotaVersion=2, and so on. Weâre going to need this information in the next step when we join the common table expression quota_cte with itself.