multi-schema query

SELECT 

    sakila_country_0.country AS sakila_country_0_country,

    sakila_city_0.city AS sakila_city_0_city,

    sakila_customer_0.first_name AS sakila_customer_0_first_name,

    sakila_customer_0.last_name AS sakila_customer_0_last_name,

    bank_account_0.account_id AS bank_account_0_account_id,

    bank_account_0.avail_balance AS bank_account_0_avail_balance

FROM

    sakila.customer sakila_customer_0

        JOIN

    sakila.address sakila_address_0 ON sakila_address_0.address_id = sakila_customer_0.address_id

        JOIN

    sakila.city sakila_city_0 ON sakila_city_0.city_id = sakila_address_0.city_id

        JOIN

    sakila.country sakila_country_0 ON sakila_country_0.country_id = sakila_city_0.country_id

        JOIN

    bank.customer bank_customer_0 ON bank_customer_0.cust_id = sakila_customer_0.customer_id

        JOIN

    bank.account bank_account_0 ON bank_account_0.cust_id = bank_customer_0.cust_id;