Zoo.adoc

SQL Zoo Queries

These answers to the SQLZoo queries give many examples of using select statements.

Table 1. SQL Zoo Examples

SQLZoo Topic	Answers	Last Checked
SELECT basics	Answers	7/21/2020
SELECT name	Answers	7/21/2020
SELECT from World	Answers	7/21/2020
SELECT from Nobel	Answers	7/21/2020
SELECT within SELECT	Answers	7/21/2020
SUM and COUNT	Answers	7/21/2020
JOIN	Answers	7/21/2020
More JOIN operations	Answers	7/21/2020
Using NULL	Answers	7/21/2020
Numeric Examples (NSS)	Answers	7/21/2020
Window function	Answers	7/21/2020
COVID 19	Answers The last question does not always give the correct answer (sort order). You may need to submit it multiple times.	7/21/2020
Self join	Answers For question 10, use the MySQL engine and insert SET SQL_BIG_SELECTS=1; before the SELECT	7/21/2020