Hello, please consider the attached Bookstore database schema and complete the following$/$ let me know what queries to use on MS SQL Server:

$1.$Create the database and its tables. Use the Field Names as given. Decide on the appropriate Data Types

$2.$ Use the INSERT queries below to add rows to the associated tables:

EMPLOYEE TABLE:

INSERT INTO EMPLOYEE

VALUES $(1,$ 'John', 'Doe', $1),$

$(2,$ 'Jane', 'Smith', $2),$

$(3,$ 'Bob', 'Johnson', $1)$;

DEPARTMENT TABLE:

INSERT INTO DEPARTMENT

VALUES $(1,$ 'Sales'$),$

$(2,$ 'Marketing'$)$;

SALESORDER TABLE:

INSERT INTO SALESORDER

VALUES $(101,1,\text{'}2024-04-01\text{'},1000\mathrm{.}00),$

$(102,2,\text{'}2024-04-05\text{'},1500\mathrm{.}50),$

$(103,3,\text{'}2024-04-10\text{'},2000\mathrm{.}75)$;

$3.$After inserting the rows to the tables, create the appropriate SQL queries to achieve the following tasks.

$3\mathrm{.}1.$Retrieve all employees whose first name starts with $\text{'}$J$\text{'}.$

$3\mathrm{.}2.$Retrieve all orders placed between April $1$st$,2024$ and April $10$th$,2024.$

$3\mathrm{.}3.$ Retrieve all departments with DepartmentID $1$ and $2.$

$3\mathrm{.}4.$Retrieve all employees who have been assigned to a department.

$3\mathrm{.}5.$Retrieve distinct combinations of EmployeeID, FirstName, and LastName from the EMPLOYEE table.

$3\mathrm{.}6.$Retrieve EmployeeID, FirstName, LastName, and DepartmentName of all employees along with their corresponding departments.

$3\mathrm{.}7.$Retrieve EmployeeID, FirstName, LastName, and OrderDate of all employees and their orders. Include all employees even if they haven't placed any orders. Hint LEFT JOIN.

$3\mathrm{.}8.$Retrieve EmployeeID, FirstName, LastName, and OrderDate of all employees and their orders. Include all employees even if they haven't placed any orders. Hint OUTER JOIN.

$3\mathrm{.}9.$Retrieve all orders placed on or after April $1$st$,2024.$

$3\mathrm{.}10.$ Add a new column 'Email' to the EMPLOYEE table. The column must have a length of $100$

$3\mathrm{.}11.$ Retrieve EmployeeID, FirstName, and LastName of employees who belong to the 'Sales' department.