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.
Learn more at Amazon Aurora MySQLSnowflake is a leading data warehouse, build for the cloud. Its unique architecture delivers proven breakthroughs in performance, concurrency and simplicity. Snowflake is a fully-managed service with a pay-as-you-go-model that works on structured and semi-structured data.
Learn more at Snowflake Data WarehouseWaste 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.