The United States says al Qaeda's second-in-command has been killed in a drone attack on Pakistan's northwest tribal region - as Sky's Mark Smith reports.