SELECT o.order_number, p.product_name, i.quantity, i.unit FROM [ order ] o JOIN order_item i ON o.id = i.order_id JOIN product p ON p.id = i.product_id ORDER BY o.order_number
Amazon Aurora is a MySQL and PostgreSQL compatible relational database built for the cloud, that combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases.1
Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse solution that makes it simple and cost-effective to efficiently analyze all of your data using your existing business intelligence tools.
Waste less time, spend less money, and scale anytime
With 100+ connectors and counting, we ensure the data in your warehouse is always up to date and accessible by analysts.View Documentation