1-- Khám phá tổng quan VNFactory
2SELECT 'dim_production_line' AS table_name, COUNT(*) AS records FROM dim_production_line
3UNION ALL
4SELECT 'dim_machine', COUNT(*) FROM dim_machine
5UNION ALL
6SELECT 'dim_product', COUNT(*) FROM dim_product
7UNION ALL
8SELECT 'dim_supplier', COUNT(*) FROM dim_supplier
9UNION ALL
10SELECT 'fact_production', COUNT(*) FROM fact_production
11UNION ALL
12SELECT 'fact_quality_inspection', COUNT(*) FROM fact_quality_inspection
13UNION ALL
14SELECT 'fact_defect', COUNT(*) FROM fact_defect
15UNION ALL
16SELECT 'fact_maintenance', COUNT(*) FROM fact_maintenance
17ORDER BY records DESC;