SQL LEARN SQL PROJECT_1
https://www.codecademy.com/courses/learn-sql/projects/learn_sql_create_table
I did this but I am sure you can do this in 2-3 lines;
update friends
set email = ‘jane@codeacademy.com’
where name = ‘Jane Smith’;
update friends
set email = ‘john@codecademy.com’
where name = ‘John Brown’;
update friends
set email = ‘charlene@codecademy.com’
where name = ‘Charlene Buckett’;
ok i google this and got; and it worked…
however - not sure why I am paying extra for say compared to data quest when I am having to google; would expect more support… really not happy no slack, no live help…
UPDATE friends
SET email =
CASE name
WHEN ‘Jane Smith’ THEN ‘jane@codecademy.com’
WHEN ‘John Brown’ THEN ‘john@codecademy.com’
WHEN ‘Charlene Buckett’ THEN ‘charlene@codecademy.com’
ELSE 0
END
WHERE name IN (‘Jane Smith’,‘John Brown’,‘Charlene Buckett’);