User Spending Ranked by Basket Value - Coding problem | OneNoughtOne
Loading content...
SQL Practice: Queries to Analytics
0/308 completed
SQL foundations
0/3
SQL Overview
5
Data Definition Language (DDL)
5
SQL Data Types
5
Filtering, ordering and expressions
0/14
Joins and relational queries
0/17
Aggregation and business metrics
0/84
Accounts Above Net Balance Threshold
Ad Campaign Click-Through Rate Ranking
Artist Presence Frequency on Streaming Chart
Average Process Duration by Machine
Cities Above National Housing Average
Compressed Order Mean Estimator
Contest Participation Rate by Event
Count Customers with Any High-Value Bill
Daily Brand Lead-Partner Reach Summary
Data Scientist Core Skill Shortlist
Department Monthly Revenue Pivot Report
Direct Report Metrics by Manager
Engineering vs Marketing Peak Salary Gap
Flight Seat Occupancy and Wait Queue Summary
Follower Base Size by User
Frequent Actor-Director Collaboration Pairs
High-Enrollment Classes Report
Highest Unique Signal Value
Immediate Dispatch Preference Percentage
Instructor Distinct Subject Count
Most Orders Customer
Player First Login Device
Player First Login Snapshot
Product Invoice Financial Rollup
Product Quantity Rollup by SKU
Project Team Experience Averages
Projects With Maximum Team Size
Query Relevance Score and Low-Rating Share
Rider Distance Leaderboard
Session Duration Bucket Distribution
Store Price Matrix by Product
Student-Subject Exam Attendance Matrix
User Spending Ranked by Basket Value
User Total Ride Distance Report
Visitors Without Checkout Activity
Warehouse Storage Volume by Facility
Yesterday Reported Post Reason Summary
Account Manager Revenue Influence Score
Active Profile Follower Connectivity Report
Age Cohort Message Action Time Share
Busiest Airport by Total Flight Traffic
Class Score Spread Analyzer
Company Salary Post-Tax Adjustment
Cross-Sell Candidates: Bought A and B, Not C
Customers With Complete Product Coverage
Daily Spam Report Clearance Rate
Department Enrollment Totals
Top Earners by Department
Driver-Passenger Role Crossover Frequency
Election Winner by Vote Count
Frequent Co-Purchase Product Pair Recommendations
High-Overlap Friendship Pairs
Investment-Ready Countries by Call Duration
League Performance Metrics by Team
Major Tournament Title Tally per Player
Member Engagement Tier by Visit-Purchase Conversion
Monthly Country Approval and Chargeback Reconciliation
Monthly Country Transaction Health Summary
Monthly Department vs Company Salary Benchmark
Most Connected User by Accepted Requests
Nearest Point Pair Distance in 2D
Nested Fruit Container Inventory Totals
Net Credit Balance and Limit Alerts
Order Peak Over Global Average
Permission Bitmask Consensus Audit
Project Assignment Seniority Leads
Qualified Interview Candidates by Experience and Round Score
Realized Gain/Loss by Stock Symbol
Retain Orders with Customer Priority Rule
Same-Day Multi-Article Viewers
School Admission Cutoff Score Planner
Signup Confirmation Success Rate by User
Social Page Recommendations with Friend Signals
Team Leads with Five Plus Direct Reports
Trial-to-Paid Engagement Averages
User Pairs with Peak Shared Followers
Co-Listening Friend Recommendation Pairs
Daily User Platform Spend Segmentation
Friend Pairs with High Same-Day Song Overlap
Half-by-Half Team Passing Control Index
Highest-Value Invoice Line Breakdown
Priority Warehouse Stock Maximization
Team Workload Outlier Project Assignments
User Network Reach Percentage
Text and data quality
0/42
Dates, intervals and time series
0/42
Windows, ranking and sequences
0/89
Recursive and graph queries
0/15
Apply it: reliable analytical exports
0/2
Course overview & roadmap
Toggle Sidebar
101
OneNoughtOne
0/308
Share