Write an SQL query for the following:

1. SELECT a character string composed of the last two digits of the year of a title's pubdate, the pub_id, and the first ten characters of the title. 2. Display in one query output table the "id", "name", city, and state of both publishers and stores. 3. Write a SELECT statement that returns these columns from the Titles table: The price column A column that uses the CAST function to return the price column with 1 digit to the right of the decimal point A column that uses the CONVERT function to return the price column as an integer A column that uses the CAST function to return the price column as an integer 4. List all rows of the titles table where title column should contain first twenty characters of the title. 5. Select all the titles published by publisher Algodata Infosystems. Use a join to show the result set. 1. SELECT a character string composed of the last two digits of the year of a title's pubdate, the pub_id, and the first ten characters of the title. 2. Display in one query output table the "id", "name", city, and state of both publishers and stores. 3. Write a SELECT statement that returns these columns from the Titles table: The price column A column that uses the CAST function to return the price column with 1 digit to the right of the decimal point A column that uses the CONVERT function to return the price column as an integer A column that uses the CAST function to return the price column as an integer 4. List all rows of the titles table where title column should contain first twenty characters of the title. 5. Select all the titles published by publisher Algodata Infosystems. Use a join to show the result set