select paper.paper_id,paper_name, paper_http from paper ,region_master,country_master where region_master.region_id=country_master.region_id and paper.country_id=country_master.country_id and region_master.region='United States' and paper_name like 'A%' group by paper_name order by paper_name