BÀI TAP SQL GUI VE MAIL

Go down

BÀI TAP SQL GUI VE MAIL

Post  Admin on 8/11/2007, 08:51

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.
avatar
Admin
Admin

Posts : 41
Join date : 2007-09-29

View user profile http://cntt207.forumotion.com

Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum