Best newsletters and posts about interactive SQL fiddle tag
Messages
4/8/2022 1:34:28 PM
Classifying animals in SQL
SQL, Database Querying, Window Function, Subquery, InterviewQs Classifying animals in SQL SQL Database Querying Window Function Subquery Forward this email to a friend or colleague and challenge them
4/27/2022 12:34:27 PM
Profit margins for all combinations of sales channels by org
SQL, Database Querying, Subquery, Cross Join, InterviewQs Profit margins for all combinations of sales channels by org SQL Database Querying Subquery Cross Join Forward this email to a friend or
6/22/2022 12:34:27 PM
Closest class scores
SQL, Database Querying, Cross Join, InterviewQs Closest class scores SQL Database Querying Cross Join Forward this email to a friend or colleague and challenge them to solve it. Hi, Suppose you are
7/1/2022 12:34:27 PM
Employee salary increase with promotion
SQL, Database Querying, Window Function, Lead Function, InterviewQs Employee salary increase with promotion SQL Database Querying Window Function Lead Function Forward this email to a friend or
7/20/2022 12:34:26 PM
Total revenue by location
SQL, Database Querying, Joining Tables, InterviewQs Total revenue by location SQL Database Querying Joining Tables Forward this email to a friend or colleague and challenge them to solve it. Hi,
8/26/2022 12:34:37 PM
Checking interview scores for accepted candidates
SQL, Database Querying, InterviewQs Checking interview scores for accepted candidates SQL Database Querying Forward this email to a friend or colleague and challenge them to solve it. Hi, Suppose your
9/23/2022 12:34:27 PM
Top keywords and advertisers
SQL, Database Querying, Window Function, Subquery, Self-Join, InterviewQs Top keywords and advertisers SQL Database Querying Window Function Subquery Self-Join Forward this email to a friend or
10/21/2022 12:34:27 PM
Calculating cost per square foot
SQL, Database Querying, Subquery, Join, InterviewQs Calculating cost per square foot SQL Database Querying Subquery Join Forward this email to a friend or colleague and challenge them to solve it. Hi,
11/18/2022 12:34:27 PM
Calculating cumulative sales with windowing functions
SQL, Database Querying, Window Function, Cumulative Sum, Subquery, InterviewQs Calculating cumulative sales with windowing functions SQL Database Querying Window Function Cumulative Sum Subquery
1/23/2023 12:34:29 PM
Finding the smallest salary difference
SQL, Database Querying, Self-Join, InterviewQs Finding the smallest salary difference SQL Database Querying Self-Join Forward this email to a friend or colleague and challenge them to solve it. Hi, You
2/1/2023 12:34:26 PM
Number of pairs in SQL
SQL, Database Querying, Subquery, InterviewQs Number of pairs in SQL SQL Database Querying Subquery Forward this email to a friend or colleague and challenge them to solve it. Hi, Suppose you're
1/4/2023 12:34:26 PM
Grouping similarly weighted animals
SQL, Database Querying, Self-join, InterviewQs Grouping similarly weighted animals SQL Database Querying Self-join Forward this email to a friend or colleague and challenge them to solve it. Hi, You
2/10/2023 12:34:29 PM
Garbage pickups and remaining capacity
SQL, Database Querying, Aggregation Functions, Join, InterviewQs Garbage pickups and remaining capacity SQL Database Querying Aggregation Functions Join Forward this email to a friend or colleague and
2/20/2023 12:34:29 PM
Locations with the lowest in store revenue
SQL, Database Querying, Window Function, Subquery, InterviewQs Locations with the lowest in store revenue SQL Database Querying Window Function Subquery Forward this email to a friend or colleague and
12/26/2022 12:34:29 PM
Histogram of daily sales in SQL
SQL, Database Querying, Subquery, Histogram, InterviewQs Histogram of daily sales in SQL SQL Database Querying Subquery Histogram Forward this email to a friend or colleague and challenge them to solve
12/7/2022 12:34:28 PM
Ranking cities by percent of their state population in SQL
SQL, Database Querying, Window Function, InterviewQs Ranking cities by percent of their state population in SQL SQL Database Querying Window Function Forward this email to a friend or colleague and
11/28/2022 12:34:28 PM
Pairing animals together based on weight difference in SQL
SQL, Database Querying, CROSS JOIN, InterviewQs Pairing animals together based on weight difference in SQL SQL Database Querying CROSS JOIN Forward this email to a friend or colleague and challenge
11/10/2022 11:45:10 AM
Moving average trading strategy
SQL, Database Querying, Window Function, Subquery, InterviewQs Moving average trading strategy SQL Database Querying Window Function Subquery Forward this email to a friend or colleague and challenge
10/31/2022 12:34:26 PM
Highest performing students by college program
SQL, Database Querying, Subquery, Case Statement, InterviewQs Highest performing students by college program SQL Database Querying Subquery Case Statement Forward this email to a friend or colleague
10/12/2022 2:28:46 PM
Percent of months logged in
SQL, Database Querying, Subquery, WITH Statement, InterviewQs Percent of months logged in SQL Database Querying Subquery WITH Statement Forward this email to a friend or colleague and challenge them to