Amazon Interview Question

1. what are views? 2. SQL query using Group by and aggregations 3. cartesian product conceptual questions