Untitled

SELECT c.nombre AS nombre_cliente, c.apellido AS apellido_cliente, v.nombre AS nombre_vendedor, v.apellido AS apellido_vendedor
FROM clientes c
JOIN ventas ve ON c.id = ve.id_cliente
JOIN vendedores v ON ve.id_vendedor = v.id
WHERE c.direccion = 'Cubas'
ORDER BY v.apellido, v.nombre;