Real Vim ninjas count every keystroke - do you?

Pick a challenge, fire up Vim, and show us what you got.

Changelog, Rules & FAQ, updates: @vimgolf, RSS.

Your VimGolf key: please sign in

$ gem install vimgolf
$ vimgolf setup
$ vimgolf put 563368fc3a2bb61edd0128f5

Manual SQL

Change select and insert queries to simulate inserting a new record.

Start file
select * from service where user_id = '908' and service_id = (233);
select * from discounts where user_id = '908';

insert into discounts values (null, 0, 908, 1, 233, 'STI-0128862-3', '2015-11-20', '2017-11-20', 0, 900, null, now());
End file
select * from service where user_id = '909' and service_id = (322);
select * from discounts where user_id = '909';

insert into discounts values (null, 0, 909, 2, 322, 'STI-0132580-2', '2015-11-01', '2018-10-01', 0, 136.8, null, now());

View Diff

1,2c1,2
< select * from service where user_id = '908' and service_id = (233);
< select * from discounts where user_id = '908';
---
> select * from service where user_id = '909' and service_id = (322);
> select * from discounts where user_id = '909';
4c4
< insert into discounts values (null, 0, 908, 1, 233, 'STI-0128862-3', '2015-11-20', '2017-11-20', 0, 900, null, now());
---
> insert into discounts values (null, 0, 909, 2, 322, 'STI-0132580-2', '2015-11-01', '2018-10-01', 0, 136.8, null, now());

Solutions by @KaizenSoze70:

Unlock 5 remaining solutions by signing in and submitting your own entry
Created by: @chuckclayton_t1

50 active golfers, 160 entries

Solutions by @KaizenSoze70:
65
#29 - Ben Hill / @KaizenSoze70

05/09/2016 at 10:35PM

70
#>33 - Ben Hill / @KaizenSoze70

05/09/2016 at 10:21PM

71
#>35 - Ben Hill / @KaizenSoze70

05/09/2016 at 10:17PM

78
#>41 - Ben Hill / @KaizenSoze70

05/09/2016 at 10:03PM

85
#>47 - Ben Hill / @KaizenSoze70

05/09/2016 at 10:01PM