Created
November 30, 2021 04:05
-
-
Save noam-honig/1f83d152b31b827272bb29d400a6ff85 to your computer and use it in GitHub Desktop.
Anonymize relational data Sql Scripts
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
create table Person( | |
social_security_number int, | |
name varchar(50) | |
) | |
create table transactions( | |
person_social_security_number int, | |
month int, | |
amount decimal | |
) | |
insert into Person (social_security_number,name) values | |
(19151, 'Tasha Robles'), | |
(13462, 'Malak Adam'), | |
(19968, 'Caden Buckner'), | |
(16057, 'Bonita Leonard'), | |
(10083, 'Yassin Broadhurst'), | |
(15442, 'Harri Cook'), | |
(15948, 'Juno Crouch'), | |
(13353, 'Domas Simmonds'), | |
(19358, 'Brenden Ellison'), | |
(12051, 'Dayna Noble') | |
insert into transactions (person_social_security_number,month,amount) | |
values | |
(19151, 1 , 6760), | |
(13462, 5 , 1442), | |
(19968, 9 , 7343), | |
(16057, 8 , 9443), | |
(10083, 4 , 2103), | |
(15442, 8 , 2463), | |
(15948, 7 , 7702), | |
(13353, 12 , 5287), | |
(19358, 12 , 5469), | |
(12051, 6 , 5741), | |
(19151, 10 , 7757), | |
(13462, 4 , 5693), | |
(19968, 1 , 3258), | |
(16057, 1 , 711), | |
(10083, 12 , 1040), | |
(15442, 2 , 9354), | |
(15948, 8 , 8279), | |
(13353, 6 , 2155), | |
(19358, 6 , 1865), | |
(12051, 5 , 7366), | |
(19151, 2 , 1514), | |
(13462, 12 , 537), | |
(19968, 10 , 6230), | |
(16057, 4 , 6856), | |
(10083, 7 , 5596), | |
(15442, 10 , 147), | |
(15948, 7 , 7152), | |
(13353, 5 , 1700), | |
(19358, 6 , 2326), | |
(12051, 6 , 8881), | |
(19151, 1 , 7866), | |
(13462, 5 , 7497), | |
(19968, 4 , 8367), | |
(16057, 9 , 4269), | |
(10083, 1 , 1153), | |
(15442, 12 , 6368), | |
(15948, 3 , 5383), | |
(13353, 12 , 7951), | |
(19358, 7 , 8103), | |
(12051, 7 , 1505), | |
(19151, 11 , 5338), | |
(13462, 1 , 4871), | |
(19968, 8 , 1157), | |
(16057, 2 , 4658), | |
(10083, 4 , 887), | |
(15442, 7 , 7402), | |
(15948, 10 , 4656), | |
(13353, 8 , 2227), | |
(19358, 8 , 8906), | |
(12051, 5 , 5866), | |
(19151, 9 , 9184), | |
(13462, 1 , 4568), | |
(19968, 4 , 4620), | |
(16057, 12 , 1115), | |
(10083, 11 , 7981), | |
(15442, 7 , 2468), | |
(15948, 9 , 9916), | |
(13353, 3 , 7926), | |
(19358, 12 , 4237), | |
(12051, 9 , 6879), | |
(19151, 12 , 4501), | |
(13462, 3 , 6587), | |
(19968, 6 , 1010), | |
(16057, 8 , 5590), | |
(10083, 1 , 3741), | |
(15442, 12 , 3433), | |
(15948, 9 , 9361), | |
(13353, 3 , 5348), | |
(19358, 2 , 650), | |
(12051, 11 , 4415), | |
(19151, 10 , 5554), | |
(13462, 12 , 9662), | |
(19968, 6 , 5567), | |
(16057, 10 , 7458), | |
(10083, 7 , 5435), | |
(15442, 2 , 859), | |
(15948, 8 , 8166), | |
(13353, 6 , 5934), | |
(19358, 12 , 9295), | |
(12051, 4 , 5071), | |
(19151, 10 , 1420), | |
(13462, 3 , 882), | |
(19968, 5 , 364), | |
(16057, 3 , 8336), | |
(10083, 2 , 991), | |
(15442, 11 , 474), | |
(15948, 4 , 8328), | |
(13353, 11 , 2106), | |
(19358, 1 , 8471), | |
(12051, 10 , 1168), | |
(19151, 6 , 2634), | |
(13462, 5 , 4730), | |
(19968, 10 , 7099), | |
(16057, 9 , 267), | |
(10083, 5 , 4755), | |
(15442, 12 , 3938), | |
(15948, 6 , 1027), | |
(13353, 10 , 3762), | |
(19358, 7 , 6729), | |
(12051, 10 , 7668) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment