Need Sql help ~ help me out

database file -> https://drive.google.com/open?id=1g5H4CET4oM7W3ZpZzDfeOpeeC_appqqm Write a query to produce a report for each store including stores without any sales. Your result-set should include the following information: • the storeID • the store name • the number of players that have purchased a badge from the store • the number of players that have not purchased a badge from the store; • the total money spent at the store • the most expensive badge a player has purchased at the store • the cheapest badge a player has purchased at the store • the average price of the items that have been purchased at the store***strong text***

You will need to provide what SQL you have tried and then we can see if we can help you arrive at your own solution.

@RandellDawson
SELECT store.storeID, store.storeName, purchase.cost,purchase.username AS whobuy FROM store INNER JOIN purchase ON store.storeID= purchase.storeID
i have try this … but when i was trying to give more complex queries it show me so earror

Hi

Did you find the error?

Carol