Merhabalar online eğitim üzerinden aldığım bir ödevde 5. soruyu halledememiş bulunmaktayım.Yardımcı olabilecek birisi varsa çok sevinirim.
Alıntı
Connect do AdventureWorksDW2017 by personal login and create SQL reports, present the result in the correct form:
1. Internet Sales reasons: Sales Reason Name, Sales Amount in milions
2. Internet Sales in customer’s regions (countries) due to Price reason Country Region Name, Sales Amount in milions
3. Based on product inventory, display top 10 products with the most changing in time Units Balance Product Name, Number of Changing, Min Units Balance, Max Units Balance
4. Reseller sales in Days of Week (advice: needs only 7 records in result) Day Name of week, Resaller Sales Amount in milions
5. Top 5 the most prospective provice of Prospective Buyer Provice Name, Numer of Prospective Buyer