Rewrite the query to restrict scans by using filter columns that match the table's clustering architecture.

Interview question asked to Data Scientists interviewing at Verizon, Viber, Indeed.com and other companies. Original question asked: Rewrite the query to restrict scans by using filter columns that match the table's clustering architecture..