FazBrowse GitHub Viewer | Trending |
URL:
| Home
Tools: [Download Repo ZIP]   [Original HTTPS Page]

UncleVee/SQLZoo: Solutions to the quizzes and SQL questions on https://sqlzoo.net/wiki/SQL_Tutorial · GitHub

 
 

Repository files navigation

SQLZoo

Solutions to the quizzes and SQL questions on https://sqlzoo.net/wiki/SQL_Tutorial

0 SELECT basics

Some simple queries to get you started

1 SELECT name

Some pattern matching queries

2 SELECT from World

In which we query the World country profile table.

3 SELECT from Nobel

Additional practice of the basic features using a table of Nobel Prize winners.

4 SELECT within SELECT

In which we form queries using other queries.

5 SUM and COUNT

In which we apply aggregate functions. more the same

6 JOIN

In which we join two tables; game and goals. previously music tutorial

7 More JOIN operations

In which we join actors to movies in the Movie Database.

8 Using Null

In which we look at teachers in departments. previously Scottish Parliament

9 Self join

In which we join Edinburgh bus routes to Edinburgh bus routes.

About

Solutions to the quizzes and SQL questions on https://sqlzoo.net/wiki/SQL_Tutorial

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors


Back | FazBrowse Home | New Git URL