QorpoID

Market materialized view -
CREATE MATERIALIZED VIEW materialized_view_asset_count AS
select sum(assets.count) from assets

Market View

CREATE VIEW view_asset_count AS
select sum(assets.count) from assets

TRM materialized view -

CREATE MATERIALIZED VIEW materialized_view_asset_count AS
select count(asset_type_id) from asset where migrated = false and location !='nitro' and asset_type_id != 30 and asset_type_id != 1

TRM view -
CREATE VIEW materialized_view_asset_count AS
select count(asset_type_id) from asset where migrated = true and location !='nitro' and asset_type_id != 30 and asset_type_id != 1

Nitro materialized view -
CREATE MATERIALIZED VIEW materialized_view_asset_count AS
select sum(assets.count) from assets

Nitro View

CREATE VIEW view_asset_count AS
select sum(assets.count) from assets

Blin Bakija wrote in #note-2:

TRM materialized view -

CREATE MATERIALIZED VIEW materialized_view_asset_count AS
select count(asset_type_id) from asset where migrated = false and location !='nitro' and asset_type_id NOT IN (1,42,100,101,110)

TRM view -
CREATE VIEW materialized_view_asset_count AS
select count(asset_type_id) from asset where migrated = true and location !='nitro' and asset_type_id NOT IN (1,42,100,101,110)