SELECT 
    h.id as asset_id, 
    'Hardware' as asset_type,
    h.name as asset_name,
    COALESCE(e.email, 'Unassigned') as employee_email
FROM hardware_assets h
LEFT JOIN employees e 
    ON h.employee_id = e.id
WHERE h.is_active = true

UNION ALL

SELECT 
    s.id as asset_id,
    'Software' as asset_type, 
    s.name as asset_name,
    COALESCE(e.email, 'Unassigned') as employee_email
FROM software_assets s
LEFT JOIN employees e 
    ON s.employee_id = e.id
WHERE s.is_active = true

ORDER BY asset_id ASC;

SELECT 
    protocol,
    traffic_in,
    traffic_out
FROM traffic
WHERE traffic_in > traffic_out
ORDER BY protocol ASC;

Project available 💯▶️

☄️Accenture  ON CAMPUS☄️ help available

Through Remote Access  🔥

🐰Those Want 100% clearance for Accenture on-campus Exams 🐰