1 - ABUSO DI LORAZEPAM - risultato Michael Jackson SELECT celebrity.name FROM celebrity, abused_by_abused_substance, abused_substance, substance_abuse_problems_celebrity WHERE abused_substance.name='Lorazepam' AND abused_substance.id=abused_by_abused_substance.id AND abused_by_abused_substance.abused_by=substance_abuse_problems_celebrity.substance_abuse_problems AND substance_abuse_problems_celebrity.id=celebrity.id ; 2 - CLINICA DOVE E' STATO RICOVERATO ROBIN WILLIAMS - risultato Hazelden - Springbrook SELECT rehab_facility.name FROM celebrity, rehab_history_celebrity, rehab_facility, celebrity_patients_rehab_facility WHERE celebrity.name='Robin Williams' AND celebrity.id=rehab_history_celebrity.id AND rehab_history_celebrity.rehab_history=celebrity_patients_rehab_facility.celebrity_patients AND celebrity_patients_rehab_facility.id=rehab_facility.id; 3 - AMICI DI BRITNEY SPEARS -risultato Madonna, Jason Trawick SELECT friend FROM friend_friendship WHERE id in (select id from friend_friendship WHERE friend='Britney Spears') AND (friend!='Britney Spears'); 4 - CHI E' STATO ARRESTATO IN UNA CITTA' (Las Vegas) - risultato O.J. Simpson SELECT legal_entanglement.celebrity FROM legal_entanglement WHERE legal_entanglement.location='Las Vegas';