SQL Query:
SELECT a.actor_id, CONCAT(a.first_name,' ',a.last_name) AS actor_name, s.shop_name, m.date_taken, m.height_in, m.chest_in, m.waist_in, m.shoe_size FROM ActorMeasurement m JOIN Actor a ON m.actor_id=a.actor_id JOIN Shop s ON m.shop_id=s.shop_id ORDER BY a.last_name;
| Actor | Gender | Shop | Date | Height" | Weight lbs | Chest" | Waist" | Hips" | Inseam" | Neck" | Sleeve" | Shoe | Hat | Notes |
|---|