Skip to content

Instantly share code, notes, and snippets.

@civera2
Last active March 22, 2018 21:15
Show Gist options
  • Save civera2/096bb6451f5defc162510415f8399767 to your computer and use it in GitHub Desktop.
Save civera2/096bb6451f5defc162510415f8399767 to your computer and use it in GitHub Desktop.
group: HR
description[[ the data for this dataset was generated using <http://www.generatedata.com/>
* the relation _Customers_ contains basic information about the customers of the bank.
* the relation _Accounts_ contains the basic information of a single account. Note that a customer can have any number of accounts.
* the relation _PremiumCustomers_ contains the customer-ids of all customers with a total balance over 1000
]]
CREATE TABLE regions (
region_id INT (11) NOT NULL,
region_name VARCHAR(25),
PRIMARY KEY (region_id)
);
INSERT INTO regions
VALUES (
1,
'Europe'
);
INSERT INTO regions
VALUES (
2,
'Americas'
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment