The merchandising team has shared several short worksheets. Each opens in a stated context, and your job is to return the requested result without changing unrelated settings. Some tasks ask for fully qualified names; others ask you to make a deliberate context switch. Read that requirement before you write the query.
These tasks revisit names, quotes and the distinction between roles and warehouses. Watch the supplier feed carefully: its quoted column names retain their case. The visible table values are examples, so use a query rule that also works when the customer names, prices and row counts change.