ValentynSQL Basics: Simple JOIN and RANKFor this challenge you need to create a simple SELECT statement that will return all columns from the people table, and join to the sales…1 min read·Oct 5, 2021----
ValentynSQL Basics: Simple table totalingFor this challenge you need to create a simple query to display each unique clan with their total points and ranked by their total points.1 min read·Oct 5, 2021----
ValentynSQL Basics: Simple HAVINGFor this challenge you need to create a simple HAVING statement, you want to count how many people have the same age and return the groups…1 min read·Oct 5, 2021----
ValentynSQL Basics: create a FUNCTIONFor this challenge you need to create a basic Increment function which Increments on the age field of the peoples table.1 min read·Oct 4, 2021----
ValentynSQL Basics: Trimming the fieldYou have access to a table of monsters as follows:1 min read·Oct 4, 2021----
ValentynSQL Basics: math with string manipulationsGiven a demographics table in the following format:1 min read·Oct 4, 2021----
ValentynSQL Basics: Repeat and ReverseUsing our monsters table with the following schema:1 min read·Oct 4, 2021----
ValentynSQL Basics — PositionYou have access to a table of monsters as follows:1 min read·Oct 4, 2021----