loader

New Year's SQL wishes... with a small quiz!

Dimitris Rebis | 05/01/2017 | wishes, SQL

Read the SQL statements to take our best wishes for the new year!

Ok, I know that you may be thinking "I am not a Database Programmer", but here at work, a Marketeer, who has no programming experience, did very well – like he tied for first for the most correct answers or something. So . . . go ahead and read!

If you do are a Database Programmer though, there is a syntax error in one of the below statements. Can you find it?

[end]

1.

select * from bestwishes

where year=2017

go

 

2.

update time

set status='Happy', year=2010+’SiEBEN’

where blogreaders='blog.sieben.gr'

go

 

3.

Insert into wishes (from, to, wish, year)

Values ('blog.sieben.gr', 'our readers', 'Happy new Year', '2017');

go

 

4.

Select top(1) solution_name, website

from best_sfa

go

Result: Pocketbiz, http://www.pocketbiz.io/

 

If you got it, then you are too SQL master! If not, please try again :-)