-
Self join - SQLZOO
Self join
stops(
SELECT COUNT(*)
FROM stops
SELECT id
FROM stops
WHERE name='Craiglockhart'
Give the
SELECT id, name FROM stops, route
WHERE id=stop
AND company='LRT'
AND num='4'
Rout...
-
SQLZOO
SQLZoo
Reference: how to...
How to create users, GRANT and DENY access, get at other peoples tables. How to find processes and kill them.
-
Using Null - SQLZOO
Using Null
Teachers and Departments
The school includes many departments. Most teachers work exclusively for a single department.
Some teachers have no department.
List the teachers who have NULL for ...
-
Nested SELECT Quiz - SQLZOO
Nested SELECT Quiz
...
Select the code that shows the name, region and population of the smallest country in each region
SELECT region, name, FROM bbc x WHERE population <= ALL (SELECT population FR...
-
JOIN Quiz 2 - SQLZOO
JOIN Quiz 2
JOIN Quiz - part 2
Select the statement which lists the unfortunate directors of the movies which have caused financial loses (gross < budget)
JOINs perform
INNER JOINs by default - th...
-
SQLZOO
How to create users, GRANT and DENY access, get at other peoples tables. How to find processes and kill them.