rafaeltedesco · November 17, 2022 16:45
diff --git a/change_value_using_case.sql b/change_value_using_case.sql
 SELECT 
    new_name,
    last_name,
    CONCAT(new_name, ' ', last_name) AS full_name
 FROM
    (SELECT 
        (CASE
                WHEN first_name = 'NICK' THEN 'LINK'
                ELSE first_name
            END) AS new_name,
            last_name
    FROM
        sakila.actor) AS SUBQ
 WHERE
    SUBQ.new_name = 'LINK';
	SELECT
	new_name,
	last_name,
	CONCAT(new_name, ' ', last_name) AS full_name
	FROM
	(SELECT
	(CASE
	WHEN first_name = 'NICK' THEN 'LINK'
	ELSE first_name
	END) AS new_name,
	last_name
	FROM
	sakila.actor) AS SUBQ
	WHERE
	SUBQ.new_name = 'LINK';
No results found