T-SQL Management Studio
Server Instance: SQL-SERVER-PROD \ Database: EnterpriseDW
← Back to Hub
Query Console (T-SQL)
▶ Execute (F5)
SELECT CategoryName, SUM(TransactionAmount) AS TotalRevenue, CASE WHEN SUM(TransactionAmount) > 500000 THEN 'High Value' ELSE 'Standard' END AS Tier FROM FactTransactions GROUP BY CategoryName;
Execution Results
CategoryName
TotalRevenue (₦)
Tier
Enterprise Logistics
1,240,000
High Value
Retail Inventory
450,000
Standard
Object Explorer
📁
Tables (Star Schema)
📄 FactTransactions
📄 DimCustomer
📄 DimDateHierarchy
📄 DimStoreLocation