Question: In this step, similar to the Comprehensive exercise - Purchase and Payment, you would need to come up with SQL codes to generate report tables
In this step, similar to the Comprehensive exercise - Purchase and Payment, you would need to come up with SQL codes to generate report tables from the database and answer questions. 1. Which store location has the highest sales (based on cash receipts amount)? And what is that amount? Similarly, which store location has the lowest sales (based on cash receipts amount)? And what is that amount? Hint: You might want to link 3 tables "stores" - "orders and sales" - "cash receipts" to find out this info. 2. Who is our biggest customer (the one we received most money from)? What is their name? Where are they located (city and state)? How much have we received from them? Hint: You might want to link 3 tables "customers" - "orders and sales" - "cash receipts" to find out this info. 3. What are our top 3 best seller flowers (based on quantity order)? 4. What is the most expensive flower type in our inventory (based on retail price)? 5. Which miscellaneous vendor (vendors misc) that we spent most money on? What is their name? Where are they located (city,state,zip)? What type of business are they (reason)? And what is the
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
