Question 1
a. Restrict City = ‘Perth’ (CUSTOMER) -> T1
Project FirstName, LastName (T1)
ack the Ripper is the best known name given to an unidentified serial killer active in the largely impoverished areas in and around the Whitechapel district of London in 1888. The name originated in a letter written by someone claiming to be the murderer that was widely disseminated in the media. The letter is widely believed to have been a hoax, and may have been written by journalists in an attempt to heighten interest in the story and increase their newspaper's circulation. Within the crime case files as well as contemporaneous journalistic accounts the killer was called "the Whitechapel Murderer" as well as "Leather Apron".
Attacks ascribed to Jack the Ripper typically involved female prostitutes who lived and worked in the slums of London and whose throats were cut prior to abdominal mutilations. The removal of internal organs from at least three of the victims led to proposals that their killer possessed anatomical or surgical knowledge. Rumours that the murders were connected intensified in September and October 1888, and letters from a writer or writers purporting to be the murderer were received by media outlets and Scotland Yard. The "From Hell" letter, received by George Lusk of the Whitechapel Vigilance Committee, included half of a preserved human kidney, purportedly taken from one of the victims. Mainly because of the extraordinarily brutal character of the murders, and because of media treatment of the events, the public came increasingly to believe in a single serial killer known as "Jack the Ripper".
Extensive newspaper coverage bestowed widespread and enduring international notoriety on the Ripper, and his legend solidified. A police investigation into a series of eleven brutal killings in Whitechapel up to 1891 was unable to connect all the killings conclusively to the murders of 1888. Five victims: Mary Ann Nichols, Annie Chapman, Elizabeth...