-- ACTIVIDAD 1

-- Crear la vista
CREATE VIEW Customer_with_companies AS
SELECT *
FROM Customer
WHERE Company IS NOT NULL;

-- 1
SELECT *
FROM Customer_with_companies
ORDER BY Company ASC;

-- 2
SELECT Company
FROM Customer_with_companies
WHERE Country = 'Brazil';