What do you think?
Rate this book
SQL Soccer Questions For MySQL: 77 practical problems with results and solutions covering the basic components of SQL
After using this book, you should know the answer to most questions relating to the English Premier League of 2018-19. Along the way you should also find out a fair amount about using SQL.
This book provides 77 questions to test your skills, as well as the results that you should get plus the 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
a) 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 functions
This book provides 77 questions to test your skills, as well as the results that you should get plus the 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
a) 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 functions
217 pages, Kindle Edition
Published May 19, 2020
2 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
No one has reviewed this book yet.