Victoria Becu

rearrange columns and use aliases

Rearranging the order we return the values from people. Making an alias of title, called old_title. Old_title and year_released are columns.

• December 16, 2016 at 11:33 PM
• Visible to public

SELECT peopleid, surname, first_name, born, died 
FROM people;

SELECT title AS old_title, year_released 
FROM movies 
WHERE year_released < 1990;