loading..
Русский    English
04:29

Football

National Football Championship. Information on a single season of one team. Each game lasts exactly 90 minutes.

Tables

Players: 

Players (player_id, first_name, last_name, nickname, citizenship, dob, role)

player_id -uniform number,

nickname - name on the uniform,

citizenship (NULL for native players),

dob – date of birth,

role - position;

Games:

Games(game_id, team, city, goals, game_date, own)

team - opposing team,

city -city where the match took place (NULL if it was a home game),

goals -goals scored by the opponent, including own goals shot by own players (NULL if not scored),

game_date - match date/time,

own - own goals by opposing team (null if there were none);

Participation in games:

Lineups(start, game_id, player_id, time_in, goals, cards)

start - 'B' - the player was in the starting lineup, 'S' - he started the match on the bench;

time_in - playing time in minutes (NULL if the player did not enter the game);

goals - the number of goals the player scored in the match (NULL if he didn't score any goals);

cards – penalty cards: 'Y' (yellow), 'Y2' (two yellow cards), 'R' (direct red), 'YR' (yellow+direct red), NULL (no cards shown).


football


Bookmark and Share
Tags
aggregate functions Airport ALL AND AS keyword ASCII AVG Battles Bezhaev Bismarck C.J.Date calculated columns Cartesian product CASE cast CHAR CHARINDEX Chebykin check constraint classes COALESCE common table expressions comparison predicates Computer firm CONSTRAINT CONVERT correlated subqueries COUNT CROSS APPLY CTE data type conversion data types database schema DATEADD DATEDIFF DATENAME DATEPART DATETIME date_time functions DDL DEFAULT DEFAULT VALUES DELETE DISTINCT DML duplicates edge equi-join EXCEPT exercise (-2) More tags
The book was updated
month ago
©SQL-EX,2008 [Evolution] [Feedback] [About] [Links] [Team]
All right reserved.