Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Customer Behavior Analysis in SQL Server

Introduction
Conversion rates
6. Conversion rates – exercise
Time to first order
Conversion charts
Summary

Instruction

Excellent! Time for an additional exercise.

Exercise

Find the conversion rate for each customer channel. Show the ChannelName and ConversionRate columns. Display the conversion rates as percentages rounded to two decimal places.

Stuck? Here's a hint!

Join tables Customers and Channels. Group by channel IDs and channel names.