Tabellen: files, objects, materials, dimensions, tube_systems, tubes, inspections, defect_classes, results Views: v_result_full, v_system_summary, v_systems_filter Beispiele: SELECT * FROM v_system_summary WHERE material_description LIKE '%TP-304%' LIMIT 100; SELECT DISTINCT description, COUNT(*) FROM materials GROUP BY 1 ORDER BY 2 DESC; SELECT client_name, COUNT(*) FROM objects GROUP BY 1 ORDER BY 2 DESC;