datastore/tests/benchmarks/tpc-ds/queries/query_84.sql

-- There are null bytes in output. The rows use FixedString(N) type, but have less than N characters. The TPC-DS specification says:
-- `Char(N) means that the column shall be able to hold any string of characters of a fixed length of N`
-- But we then get strings of less than N characters and as result have the null bytes in the output. We deem such result as correct.
SELECT
    c_customer_id AS customer_id,
    concat(coalesce(c_last_name, ''), ', ', coalesce(c_first_name, '')) AS customername
FROM customer, customer_address, customer_demographics, household_demographics, income_band, store_returns
WHERE (ca_city = 'Edgewood')
    AND (c_current_addr_sk = ca_address_sk)
    AND (ib_lower_bound >= 38128)
    AND (ib_upper_bound <= (38128 + 50000))
    AND (ib_income_band_sk = hd_income_band_sk)
    AND (cd_demo_sk = c_current_cdemo_sk)
    AND (hd_demo_sk = c_current_hdemo_sk)
    AND (sr_cdemo_sk = cd_demo_sk)
ORDER BY c_customer_id
LIMIT 100;