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: Pobuca Sales, http://sales.pobuca.com
If you got it, then you are too SQL master! If not, please try again :-)