-- Objective: Collect top product names per department into arrays. -- Data/location: thelook_ecommerce.products (US). -- Expected result: One ordered three-name array per department. -- Standard ...

Arrays cannot be represented directly in SQL-92, but they are a common vendor language extension that became part of SQL-99. Arrays violate the rules of First Normal Form (1NF) required for a ...