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.
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
Did you find the error?