Liking cljdoc? Tell your friends :D

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

Can you improve this documentation?Edit on GitHub

cljdoc is a website building & hosting documentation for Clojure/Script libraries

× close