CS50/favorites

favorits.sql

UPDATE shows SET title = "How I Met Your Mother" WHERE title LIKE "How i met your mother";
UPDATE shows SET title = "Adventure Time" WHERE title LIKE "Adventure Time";
UPDATE shows SET title = "Arrow" WHERE title LIKE "Arrow";
UPDATE shows SET title = "Avatar: The Last Airbender" WHERE title LIKE "Avatar: The Last Airbender";
UPDATE shows SET title = "Community" WHERE title LIKE "Community";
UPDATE shows SET title = "Family Guy" WHERE title LIKE "Family Guy";
UPDATE shows SET title = "Friends" WHERE title LIKE "Friends";
UPDATE shows SET title = "Game of Thrones" WHERE title LIKE "Game of Thrones" OR title LIKE "Got";
UPDATE shows SET title = "Gilmore Girls" WHERE title LIKE "Gilmore Girls";
UPDATE shows SET title = "Grey’s Anatomy" WHERE title LIKE "Grey’s Anatomy" OR title LIKE "Grey%";
UPDATE shows SET title = "It’s Always Sunny in Philadelphia" WHERE title LIKE "It’s Always Sunny in Philadelphia";
UPDATE shows SET title = "Parks and Recreation" WHERE title LIKE "Parks and Recreation" OR title LIKE "Parks and Rec";
UPDATE shows SET title = "Sherlock" WHERE title LIKE "Sherlock" OR title LIKE "Sherlock Homes" OR title LIKE "sherlock holmes%";
UPDATE shows SET title = "Squid Game" WHERE title LIKE "Squid Game";
UPDATE shows SET title = "The Bachelorette" WHERE title LIKE "The Bachelorette";
UPDATE shows SET title = "The Crown" WHERE title LIKE "The Crown";
UPDATE shows SET title = "The Office" WHERE title LIKE "The Office" OR title LIKE "Office" OR title LIKE "Thevoffice";
UPDATE shows SET title = "The Queen’s Gambit" WHERE title LIKE "The Queen’s Gambit";
UPDATE shows SET title = "The Untamed" WHERE title LIKE "The Untamed";
UPDATE shows SET title = "Brooklyn Nine-Nine" WHERE title LIKE "Brooklyn 99" OR title LIKE "Brooklyn Nine-Nine" OR title LIKE "Brooklyn-99" OR title LIKE "brooklyn 99" OR title LIKE "B99";
UPDATE shows SET title = "Billions" WHERE title LIKE "billions%";
UPDATE shows SET title = "Criminal minds" WHERE title LIKE "criminal minds%";
SELECT * FROM shows ORDER BY title ASC;