Question
Use database in following URL to solve for following questions and provide SQL queries. https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all 1. What is the postal code of the customer that
Use database in following URL to solve for following questions and provide SQL queries.
https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all
1. What is the postal code of the customer that lives in Elgin US?
2. How many employees were born in September?
3. How many Countries have only one supplier?
4. Find the category that has the most expensive products (on average).
5. What is the customer id that purchased the most products (Quantity)?
6. Find the most profitable orderID and the revenue from the order.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Object Databases The Essentials
Authors: Mary E. S. Loomis
1st Edition
020156341X, 978-0201563412
