From the course: Introduction to SQL Using Google BigQuery
Join today to access over 24,900 courses taught by industry experts.
Challenge: Wisdom Pet, quiz 2 - SQL Tutorial
From the course: Introduction to SQL Using Google BigQuery
Challenge: Wisdom Pet, quiz 2
(upbeat music) - [Instructor] Welcome to our next assignment from the Wisdom Pets team. This time, we've been tasked with creating some outputs for the accounting team who need to calculate total sales, discounts, and other metrics from our data set. The following questions they would like answered include, one, what is the average transaction size for wholesale and retail, split by VIP status? And two, what is the total discount amount for all wholesale transactions? These challenge questions are phrased in a more business specific manner with some level of uncertainty. Part of the challenge is to try and understand what data elements are being asked for, and how you can combine our data sets using specific table joins to implement a suitable solution. Good luck with these questions, and I'll see you when you're ready to validate your big query code.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.