Day21 - SELECT UPPER(first_name) AS FirstName,...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
SELECT UPPER(first_name) AS FirstName, UCASE(last_name) AS LastName FROM people SELECT CONCAT(first_name, ' ', last_name) AS FullName, CONCAT(UPPER(first_name), ' ', UCASE(last_name)) AS up_name FROM people Create a listing of all people with a first name starting with Cath with each person's name displayed as a and then first name (e.g., Adams, Cathy). [about 2366] ------ SELECT CONCAT (last_name,',', first_name) AS name FROM people WHERE first_name LIKE "Cath%" ORDER BY last_name Create a listing of all movies from 2006 with a single field per movie that contains the name of the movie followed by a slash and then the movie's rating. Sort the list alphabetically by movie title (e.g., 16 Blocks/PGCSE 101 - Database Track - Day 21 - NEW 10 PG- 13). [568] ------ SELECT CONCAT(title, '/', rating_code) AS "title/rating" FROM movies AS m INNER JOIN movie_ratings AS mr ON m.movie_id = mr.movie_id WHERE release_year = 2006 ORDER BY title List all people having a last name starting with
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/14/2011 for the course CSE 101 taught by Professor Allusethis during the Fall '08 term at Michigan State University.

Page1 / 3

Day21 - SELECT UPPER(first_name) AS FirstName,...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online