1. Write a query that will show all publishers

2. Write a query that will show the name and phone # of publishers

3. Now write a query that shows publisher name and phone # of publishers. Include the field pubid but rename pubid to Publisher ID

4. Write a query that will show crime id, and the number of days between date charged and the hearing date for each crime ID. Include an alias for the new virtual column called # of days.

5. Write a query that will concat the publisher name and phone # into one column. Add a space between the publisher name and phone #. Give the column the alias Publisher Phone.