Question: SQL Modes
Explore how to adjust MySQL SQL modes to support BI tool queries that use double-quoted identifiers and require deterministic aggregation. Understand configuring ONLY_FULL_GROUP_BY mode, and practice writing queries that comply with these constraints, ensuring accurate reporting and total spending calculations.
We'll cover the following...
Question
Given the following structure of the Customers table:
Field | Type |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Where, CustomerID is the primary key and ReferralID is self-referencing to CustomerID. The table contains information about customers. In the table, each customer is categorized by a CustomerTier to reflect their engagement ...