GitHub - ainsleyains/Codewars---PostgreSQL: Leveling up my SQL skills one query at a time

Name		Name	Last commit message	Last commit date
1. Find all active students		1. Find all active students
101 Dalmatians - squash the bugs, not the dogs!		101 Dalmatians - squash the bugs, not the dogs!
ABC Kata Solutions' Failures That Paved the Road to Success		ABC Kata Solutions' Failures That Paved the Road to Success
ASCII Patterns Using SQL: part 1		ASCII Patterns Using SQL: part 1
ASCII Patterns Using SQL: part 2		ASCII Patterns Using SQL: part 2
ASCII Patterns Using SQL: part 3 (heart shape ❤️)		ASCII Patterns Using SQL: part 3 (heart shape ❤️)
Action Movie Rentals: Finding the Most Popular Day Of Week		Action Movie Rentals: Finding the Most Popular Day Of Week
Adults only (SQL for Beginners #1)		Adults only (SQL for Beginners #1)
Aggregate Transaction Durations of ATMs		Aggregate Transaction Durations of ATMs
All-Inclusive Shoppers		All-Inclusive Shoppers
Alphabetical Addition		Alphabetical Addition
Analyzing Customer Rental Trends: Identifying Popular Movie Genres Across Multiple Months		Analyzing Customer Rental Trends: Identifying Popular Movie Genres Across Multiple Months
Analyzing the sales by product and date		Analyzing the sales by product and date
BASICS: Length based SELECT with LIKE		BASICS: Length based SELECT with LIKE
Backend Team's Tradition: An Age-Alternating Introduction		Backend Team's Tradition: An Age-Alternating Introduction
Backtracking Contributions: Unveiling the Penultimate Team Member in Project Task Management		Backtracking Contributions: Unveiling the Penultimate Team Member in Project Task Management
Bakery Delight: Querying Custom Cakes with Perfect Decorations		Bakery Delight: Querying Custom Cakes with Perfect Decorations
Balance history		Balance history
Beginner Series #2 Clock		Beginner Series #2 Clock
Best-Selling Books (SQL for Beginners #5)		Best-Selling Books (SQL for Beginners #5)
Blocks in an Irregular Pyramid		Blocks in an Irregular Pyramid
Building a User Leaderboard with Engagement Metrics		Building a User Leaderboard with Engagement Metrics
Calculate Pyramid Height		Calculate Pyramid Height
Calculating Batting Average		Calculating Batting Average
Calculating Daily Registrations and 8-Day Running Averages		Calculating Daily Registrations and 8-Day Running Averages
Calculating Running Total		Calculating Running Total
Cantor's pairing function		Cantor's pairing function
Categorize and Count Job Applications Based on Status		Categorize and Count Job Applications Based on Status
Cats and shelves		Cats and shelves
Centered pentagonal number:		Centered pentagonal number:
Century From Year		Century From Year
Chaser's schedule		Chaser's schedule
Checkerboard Resolution		Checkerboard Resolution
Chessboard Squares Under Queen's Attack		Chessboard Squares Under Queen's Attack
Classifying Transactions by Number of Suppliers		Classifying Transactions by Number of Suppliers
Cleaning IP Addresses: Removal of Leading Zeros		Cleaning IP Addresses: Removal of Leading Zeros
Code golf: Simple short select		Code golf: Simple short select
Collect Tuition (SQL for Beginners #4)		Collect Tuition (SQL for Beginners #4)
Complementary DNA		Complementary DNA
Conditional Count		Conditional Count
Conditional Grouping of User Activities		Conditional Grouping of User Activities
Constructing a Student-Course Relationship Map		Constructing a Student-Course Relationship Map
Convert boolean values to strings 'Yes' or 'No'.		Convert boolean values to strings 'Yes' or 'No'.
Count Odd Numbers below n		Count Odd Numbers below n
Count Weekdays		Count Weekdays
Count a Spiral		Count a Spiral
Count by X		Count by X
Count consonants		Count consonants
Count the number of cubes with paint on		Count the number of cubes with paint on
Counting Interview Failures Without Using COUNT()		Counting Interview Failures Without Using COUNT()
Countries Capitals for Trivia Night (SQL for Beginners #6)		Countries Capitals for Trivia Night (SQL for Beginners #6)
Creating a Simple Contingency Table in SQL		Creating a Simple Contingency Table in SQL
Current Age Distribution of Employees		Current Age Distribution of Employees
Customer Orders: Products 1 & 2, Excluding 3		Customer Orders: Products 1 & 2, Excluding 3
Customer Rebates Based on Total Orders for September 2023		Customer Rebates Based on Total Orders for September 2023
Customer Support System: Users with Multiple Distinct Usernames		Customer Support System: Users with Multiple Distinct Usernames
Customers with All Orders Undelivered		Customers with All Orders Undelivered
Customers with Urgently Expiring Certificates		Customers with Urgently Expiring Certificates
Daily Hospital Admissions and Discharges Report		Daily Hospital Admissions and Discharges Report
Days to Reach a Cumulative Transaction Threshold		Days to Reach a Cumulative Transaction Threshold
Deal Activity Analysis		Deal Activity Analysis
Diophantine equation#2		Diophantine equation#2
Disemvowel Trolls		Disemvowel Trolls
Doors in the school		Doors in the school
Drug Dosages with Dual Unit Measurements		Drug Dosages with Dual Unit Measurements
Easy SQL - Ordering		Easy SQL - Ordering
Easy SQL: ASCII Converter		Easy SQL: ASCII Converter
Easy SQL: Absolute Value and Log to Base		Easy SQL: Absolute Value and Log to Base
Easy SQL: Bit Length		Easy SQL: Bit Length
Easy SQL: Convert to Hexadecimal		Easy SQL: Convert to Hexadecimal
Easy SQL: Counting and Grouping		Easy SQL: Counting and Grouping
Easy SQL: Cube Root and Natural Log		Easy SQL: Cube Root and Natural Log
Easy SQL: LowerCase		Easy SQL: LowerCase
Easy SQL: Moving Values		Easy SQL: Moving Values
Easy SQL: Rounding Decimals		Easy SQL: Rounding Decimals
Easy SQL: Square Root and Log		Easy SQL: Square Root and Log
Employee Weekend Work: Counting Unique Weekends and Total Days Worked		Employee Weekend Work: Counting Unique Weekends and Total Days Worked
Employees and managers: Part 1		Employees and managers: Part 1
Employees and managers: part 6 (Old is Gold)		Employees and managers: part 6 (Old is Gold)
Even Fibonacci Sum		Even Fibonacci Sum
Even fusc fun		Even fusc fun
Even or Odd		Even or Odd
Exact Match: Agents Sharing the Same Workload		Exact Match: Agents Sharing the Same Workload
Exclude 'Adults only' films watchers		Exclude 'Adults only' films watchers
Expressions Matter		Expressions Matter
Extract Direct Subdirectories		Extract Direct Subdirectories
Extracting and Comparing Raising Bids for Products		Extracting and Comparing Raising Bids for Products
Extracting and Ranking Unique Tags		Extracting and Ranking Unique Tags
Fake Binary		Fake Binary
Film Category Ratings Breakdown		Film Category Ratings Breakdown
Filtering Films by Special Features in PostgreSQL: Part 1		Filtering Films by Special Features in PostgreSQL: Part 1
Filtering Films by Special Features in PostgreSQL: Part 2		Filtering Films by Special Features in PostgreSQL: Part 2
Filtering Films by Special Features in PostgreSQL: Part 3		Filtering Films by Special Features in PostgreSQL: Part 3
Filtering Films by Special Features in PostgreSQL: Part 4		Filtering Films by Special Features in PostgreSQL: Part 4
Filtering Films by Special Features in PostgreSQL: Part 5		Filtering Films by Special Features in PostgreSQL: Part 5
Find Messages with Multiple Occurrences of a Word "Apple" 🍎		Find Messages with Multiple Occurrences of a Word "Apple" 🍎
Find users whose maximum order amount is greater than the average order amount of all orders.		Find users whose maximum order amount is greater than the average order amount of all orders.
Finding Batch Temperature Fluctuations in Manufacturing Processes		Finding Batch Temperature Fluctuations in Manufacturing Processes
Finding Products Matching All Selected Tags		Finding Products Matching All Selected Tags
Finding people with a speeding record		Finding people with a speeding record

Latest commit

History

Folders and files

About

Stars

Watchers

Forks

Releases

Packages

Contributors