SQL Soccer Questions World Cup 2018: One hundred problems with one hundred results and solutions covering the basic components of SQL using data from the soccer World Cup of 2018.

by James Riddle

Do you know who was the youngest defender to score for his country in the 2018 World Cup?After using this book you should know how to get the answer as well as being able to tackle many other questions about that soccer competition. Along the way you should also find out a fair amount about using SQL.This book provides100 other questions to test your skills, using data from the 2018 World Cup. It shows the 100 results that you should get plus 100 SQL query scripts that would produce them.For each question you can either go straight to the solution, or first check the result so see what output is required and then create your own SQL script to give something that matches.Most questions require you to use the appropriate Where and Order By clauses to ger the right filtering and sorting of the data. The other main SQL topics Joins, inner and outer ; b) Subqueries ; c) Common Table Expressions and Inline Views; d) Summary and Group functions; e) Case statements; f) Set operators; g) Date, text and number functionsBy the way, the answer to that question is Moussa Wague, representing Senegal against Japan in a match played on June 24th.

Kindle Edition

Published October 4, 2020