Programming for data science with Python > INTRODUCTION TO SQL
chapter 15. Solutions: GROUP BY
Solutions for quiz 7 and 8 are missing.
- What was the smallest order placed by each account in terms of total usd. Provide only two columns - the account name and the total usd. Order from smallest dollar amounts to largest.
- Find the number of sales reps in each region. Your final table should have two columns - the region and the number of sales_reps. Order from the fewest reps to most reps.
Please sign in to leave a comment.