Please Answer using Microsoft SQL server, Thank you.

Write create statements to create the following two tables for "Good Reading" bookstore and insert 2 records in each table. Make sure you enforce the following and Choose the correct data types for the columns 1) Date columns need to be of type Date 2) Author numbers are 5-digit alphanumeric string, two letters and three numbers. 3) You want to minimize disk space requirements. Identify the columns that should be fixed length string types, and which should be variable length string types. 4)Tables must be created in the schema "Good Reading" Table 1: Write SQL queries to create table and insert 2 records PUBLISHER Publisher Name City Country Telephone YearFounded Table 2: Write SQL queries to create table and insert 2 records AUTHOR AuthorNumber AuthorName YearBorn