BÀI TAP SQL GUI VE MAIL

CÁC BẠN LÀM CÁC BÀI TẬP DƯỚI ĐÂY, ĐÓNG GÓI .ZIP VÀ GỬI VỀ EMAIL cntt207@gmail.com CHO THẦY.

http://sqlzoo.net

1) SELECT:
In which we query the BBC country profile table.
2a) More practice with SELECT:
Additional practice of the basic features using a table of Nobel Prize winners.
2b) SELECT in SELECT:
In which we form queries using other queries.
3) SUM and COUNT:
In which we apply aggregate functions.
4) The JOIN operation:
In which we join two tables; ttms and country. (previously music tutorial)
5) More JOIN operations:
In which we join actors to movies in the Movie Database.
6) The OUTER JOIN:
In which we include the parties without people and the people outwith parties in the Scottish Parliament.
7) Self join:
In which we join Edinburgh bus routes to Edinburgh bus routes.