DTCC, Recently Asked Online Assessments in 2026 | SQL UNION Query | Recursive Function Tracing

Question 1: List Customer and Product Without Sale (SQL) Problem Statement: Using the UNION operator, in one list return all customers who do not have an invoice and all products that were not sold. For each customer without an invoice, return: the string customer the customer id the customer_name For each product without an invoice, return: the string product the product id the product_name The columns must be in the order shown, but row order does not matter. Table Definitions ...