SQL Soccer Questions For Oracle: 77 SQL Exercises

by James Riddle

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 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

100 pages, Paperback

Published May 21, 2020