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,\text{'}$Sales$\text{'}),$

$(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.