Table: celebrity_photos
Columns: type
person_s
publisher_s
publication_date
reported_price

Question: What type of photos of Angelina Jolie cost $500,000?
SQL: SELECT "type" FROM celebrity_photos WHERE "reported_price" = '$500,000' AND "person_s" = 'angelina jolie'

Question: What was the publication date of the photos of Sean Preston Federline that cost $500,000 and were published by People?
SQL: SELECT "publication_date" FROM celebrity_photos WHERE "reported_price" = '$500,000' AND "publisher_s" = 'people' AND "person_s" = 'sean preston federline'