Курсовая работа: Создание базы данных "Wc3 Cybersport Data Base"

4.SQL-запросы

[All Russia Players]

SELECT *

FROM players

WHERE country='Russia'

[All unknown players]

SELECT *

FROM players

where [Full name]='?' or age=0

[Eldest Players]

SELECT *

FROM players

WHERE age between 20 and 30

[Count by Country]

Select Country, count(Nickname) as Players

From players

Group By country

Order by count(Nickname) desc

Group by [место проживания]))

[Domain Country in Clan]

DROP TABLE temp

CREATE TABLE temp

(clan CHAR (15),

players INT ,

country CHAR (60))

INSERT

INTO temp

select Clan, count(Nickname) as Players, Country

From players