Правильное написание VIEW

CREATE VIEW counte AS
SELECT customers.id_password AS idp, COUNT(exzemp.id) AS cnt
FROM customers
JOIN orders ON (orders.id_customer=customers.id_password)
JOIN exzemp ON (SELECT FIO, id_password, exzemp.id_order=orders.id)
GROUP BY customers.id_password, orders.id
HAVING COUNT(exzemp.id)>1
;
 
SELECT FIO, id_password, 
FROM counte
JOIN customers ON (customers.id_password=counte.idp)
ORDER BY FIO, id_password
;

CREATE VIEW A AS
SELECT customers.id_password AS idp
FROM customers
JOIN orders ON (orders.id_customer=customers.id_password)
JOIN exzemp ON (exzemp.id_order=orders.id)
GROUP BY customers.id_password
;
 
CREATE VIEW B AS
SELECT customers.id_password AS idp
FROM customers
JOIN orders ON (orders.id_customer=customers.id_password)
JOIN exzemp ON (exzemp.id_order=orders.id)
GROUP BY customers.id_password
HAVING COUNT(exzemp.id)=1
;
 
SELECT FIO, id_password
FROM customers
JOIN A ON (A.idp=customers.id_password)
JOIN B ON (B.idp=customers.id_password)
WHERE A.idp<>B.idp
;

CREATE VIEW customer2 AS
SELECT c.*,
(SELECT COUNT(*) FROM orders2 o WHERE o.id_customer = c.id_passport) AS allorders,
(SELECT COUNT(*) FROM orders2 o WHERE o.id_customer = c.id_passport AND o.allcnt > 1) AS allorders2
FROM customer c;
 
SELECT FIO, id_passport FROM customer2 WHERE allorders = allorders2;

CREATE VIEW orders2 AS
SELECT o.id_customer, 
      (SELECT COUNT(id) 
       FROM exzemp e
       WHERE e.id_order = o.id) AS allcnt
FROM orders o;
 
 
CREATE VIEW customer2 AS
SELECT c.id_password,c.fio,
    (SELECT COUNT(id_customer) 
     FROM orders2 o 
     WHERE o.id_customer = c.id_password) AS allorders,
    (SELECT COUNT(id_customer)
     FROM orders2 o
     WHERE o.id_customer = c.id_password AND o.allcnt > 1) AS allorders2
FROM customers c;
 
 
SELECT FIO, id_password 
FROM customer2 
WHERE allorders = allorders2
ORDER BY FIO, id_password;