Last updated Nov 17, 2024

Use the magic store database for the following queries.

3. Write a query to show all products that cost more than 1 and less than 100. Display the product name, the product’s supplier name and the product’s price. Rename the price column as “Price (USD)”, product name column as “Product Name” and the supplier name column as “Supplier Name”.

Expected results:

• SQL - W10 Advanced Querying - Introduction
• SQL - W10 Advanced Querying - Aggregate Functions
• SQL - W10 Advanced Querying - Column Aliasing
• Next: SQL - W10 Advanced Querying - Calculating Values
• SQL - W10 Advanced Querying - Northwind Database
• SQL - W10 Advanced Querying - GROUP BY
• SQL - W10 Advanced Querying - Data Analytics with GROUP BY
• SQL - W10 Advanced Querying and Data Analytics Assignment