Data Analytics
732 learners
Mastering SQL Functions and Clauses
Take your SQL expertise to the next level by harnessing the power of SQL functions. Using data from an online shopping platform, this course delves into advanced SQL functions and clauses, helping you summarize, count, and differentiate data to gain deeper insights into shopping datasets.
MySQL
5 lessons
25 practices
2 hours
Data Analysis for Insights
Lessons and practices
Counting Rows in SQL
Counting Conditioned Rows in Orders Table
Fix the SQL Query
Counting Rows in a Table
Counting Selected Customer Orders
Extracting Category IDs Query
Finding Unique Category IDs
Fix the Unique Category Query
Unique Product with Support Retrieval
Unique Product Identification Task
Summing Orders by Category
Summing Items Sold by Categories
Fix the Aggregate Function Query
Summarize Events by Category
Mastering SQL Aggregate Functions
Exploring Yearly Shop Performance
Analyzing Yearly Shop Performance
Analyze Shop Performance by Years
Grouping Matches by Season
Counting Supports by Order Date for Specific Years
Fix SQL Aggregation Query
Fix the Aggregate Query
Calculate Average Supports Selected Per Year
Calculate Total Supports Selected
Aggregate Yearly Extended Supports
Meet Cosmo:
The smartest AI guide in the universe
Our built-in AI guide and tutor, Cosmo, prompts you with challenges that are built just for you and unblocks you when you get stuck.
Join the 1M+ learners on CodeSignal
Be a part of our community of 1M+ users who develop and demonstrate their skills on CodeSignal
